Please help me focus!!!

[diplomat]

I don't know if this has to do with Focus or something else (in addition to my naivete), but here is my problem.

I have two pages (BigForm1 and BigForm2) for data entry. The two page have the same top part (the main form) which contains the customer id data (LastName, FirstName, gender, dob, ht, wt, idcode, etc), but have different subforms. How can I make sure that when the user is done inputting data in BigForm1 and goes to BigForm2 finds the top part of this page already populated with the customer id data and the cursor is at the subform immediately below it? In other words, how can I fill out the top part of both pages at the same time?

By the way, you move from BigForm1 to BigForm2 by clicking a command button that works with a macro (close BigForm1, open BigForm2).

Thanks!!!

 

[Carol]

In the top part of your second main form put the following in the default of each field name that you want populated.
=[Forms]![BigForm1]![FieldName]
Each field should correspond to the field on your 1st Form.
I would also suggest another way.
Make 1 Main Form to hold the relevent information that pertains to the two subforms and either use 2 subforms for your data entry or use a macro to move between them.

 

[diplomat]

Thanks Carol!! I will try your first suggestion; the second is very clear to me yet.