Have I screwed up?
I have 3 forms that are related to each other – Forms 2 and 3 contain subset information about the subject started on Form 1.
I’m getting stuck on how to link the forms together and add a button on Form 1 that will open Form 2, and a button on Form 2 that will open Form 3. The other option is to have each Form appear a tab that can be clicked by the user.
Right now, I have built each individual form (with it’s subforms). I have the Primary Key field from Form 1 on Forms 2 and 3. I can’t though, get the record number from Form 1 to auto populate on the other forms to show that all the data is related.
Is there a way to fix this and add the command buttons or tabs, or will it be better for me to take a different approach and start from scratch?
What am I missing? Did I skip a step in the process or get something out of order?