The main record is going to be added in a form, but what I'm finding is that the related records can't be added until the main record is added (I have relationships setup). That's a catch 22 because in order to finalize the record I have to leave the form.
What is the best way to detect a new record in VBA code?
.newrecord isn't exactly what I want either.
What I want is when a record is added to a table I want to automatically add 4 records to another table.
Thanks.
First of all...this forum is nice! Lots of information. It's been a great help for me already.
Now my problem.
I have 2 forms.
The main form and then another form I want to pop up when I need more information.
I'm a little confused on how to do this.
Do I have to create a new instance of...