Terry-
How is the table containing those three fields related to the table you're
editing? Access might fetch that info for you automatically if you include that
table in your form's Record Source, and it's linked on Badge.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Villefranche-sur-mer, France)
-----------------------------------
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Terry Olsen
Sent: Saturday, April 21, 2012 6:45 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Forms Population Question
For a new entry, I have a data entry form that I want to reduce keystrokes on.
In one bound control, badge, after initial data entry, I want to populate three
other text boxes, txtEmployeeId, txtEmployeePin, and txtEmployeeID. After all
entries on the form are complete, I want to populate fields in the DB table
columns for each of them.
Which event do I use?
What persists the data to the relevant DB record?
Thanks
Terryomsn
Tidak ada komentar:
Posting Komentar