Unanswered: Problem adding new record in tab control
I have a medical database setup with a form including a tab control with two tabs…patients and medications/conditions. The patients tab holds a single form. The medications/conditions tab holds two individual continuous subforms by query for medications and conditions. This is working perfectly for old records, I can switch between tabs and the PatientID follows and shows the related meds and conditions.
The problem is, I cannot add a new record. I get the following dialog when I enter the first character in any field on the patients form.
If I hit OK, It will assign a new PatientID and allow me to continue entering data and even saves the data, but the PatientID does not follow to the medications/conditions tab(I have test PatientID controls in the forms). I can enter data in the medication/condition forms but it does not save that data because no PatientID is related to those records. I think I’m missing something simple but I am relatively new to Access. Any suggestions would be appreciated.