I have 3 tables, tbl_Records, tbl_Clients and tbl_Salesperson where tbl_Records is my main table. tbl_Clients and tbl_Salsperson are enforced to tbl_Records (1 Client,Salesperson to many Records)
I have built a form with 2 subforms displaying the client and salesperson data for each Record. The Subforms are purely for display purpose and are read only. The data comes from two other pop up forms. The pop ups return record IDs to the main form and store them in the Foreign Key fields. The idea is that the subforms then get requeried to display the correct record.
My problem is that I cannot requery either subform until both subforms have been populated with data. Error 3201, "Related record required in ... ". Is there anway I can requery the individual subforms wihtout having to populate them both first?