Unanswered: Connect forms by putting PatientID on every form and making it lookup ID from form
I have a form on multiple pages that fills in data for multiple tables that are all connected by a patientID field. However, when I fill in the form the data is saved except for the patientID. The first page of the form (patient information) saves the patientID number and I need to the other pages to fill in the patientID field with that same number so all the information will be connected. However, I want the patientID field to be invisible because it doesn't affect the user at all. So I have them all set to hidden, but I still need to have them lookup the patientID number from the first page of the form. How would I do this?
I know a little about looking up fields and am thinking I would use something like [Forms]![newPatient]![combo12]. But I don't know where to put this code????