New at Access: Update simlar text fields in one form based on another form

SD23

Registered User.
Local time
Today, 14:06
Joined
Jun 13, 2006
Messages
60
I am very new at Microsoft Access. I have two forms, A and B, that are filled out by two different users. Form A gets filled out first than form B gets filled out. Each has a name box as well as a birthdate box and a few other similar text fields. However, each form also has a few distinctive fields. I was wondering how I could input the common information in Form A to Form B so the user of Form B does not have to spend time retyping the name and birthdates again. In other words, I want to synchronize the similar records between the two forms. I would like the values to appear in a table as well. I would greatly appreciate it if someone could help me with the visual basic code. Thank You.
 
Something like this might work.

under properties/control source
=[Forms]![frmFormA]![Name]
 

Users who are viewing this thread

Back
Top Bottom