I have a main form (Table "A") with a command button that opens form "Sets"(Table "Sets"). When a new record is created in the main form I want to be sure that the "Sets" form has a corresponding and linked record even when the form has not been opened.
The linking field between the forms is ItemNumber. So in the past I have used
"If IsNull(Form![Sets].ItemNumber) Then "Sets" form!Sets.ItemNumber =MainForm.ItemNumber"
I am sure that this will not work if the form is closed but I don't want the user to have to open the form or program an open and close procedure.
Is there something in access like ""Always create a record in the "Sets" table where Table "A" has a record
Or would that happen naturally if the tables are linked on a 1 to 1 basis