Hi all,
I have created a database with 2 forms - form1 displaying data from table1 and form2 displaying related records from table2.
form1 has a button which opens form2. If a related record exists in table2 then form2 displays the correct record... however, if no record exists already then form2 is blank.
My problem is that when a user enters information into a blank form2, the record will not save because "a related record is required" in table1. How can I carry across the ID field from form1 to the blank record in form2. I tried putting [forms].[form2].[idnumber]=[forms].[form1].[idnumber] into the BeforeUpdate property of form2 but this doesnt work... any help would be much appreciated!
Many thanks in advance,
Trevor
I have created a database with 2 forms - form1 displaying data from table1 and form2 displaying related records from table2.
form1 has a button which opens form2. If a related record exists in table2 then form2 displays the correct record... however, if no record exists already then form2 is blank.
My problem is that when a user enters information into a blank form2, the record will not save because "a related record is required" in table1. How can I carry across the ID field from form1 to the blank record in form2. I tried putting [forms].[form2].[idnumber]=[forms].[form1].[idnumber] into the BeforeUpdate property of form2 but this doesnt work... any help would be much appreciated!
Many thanks in advance,
Trevor
