E
Engels
I want to get my form to open to a new record IF there are no existing
records matching the filter on a button on the previous form and to carry
some data over from the previous form.
The basic set up is this:
I have a form "Course Setup" that takes it's data from a table [Training
Course] this links to a form "Catering" which displays data from the
[Catering] table.
PK on [Training Course] is [Course ID] & is a foreign key on [Catering]
I used the wizard to create a button on the main form to link them and do a
filtered search to bring up only the catering records which have the same
[Course ID] as on the previous form.
When there is no existing record I need the form to open up to a new record
automatically entering the [Course ID] of the preceding form.
records matching the filter on a button on the previous form and to carry
some data over from the previous form.
The basic set up is this:
I have a form "Course Setup" that takes it's data from a table [Training
Course] this links to a form "Catering" which displays data from the
[Catering] table.
PK on [Training Course] is [Course ID] & is a foreign key on [Catering]
I used the wizard to create a button on the main form to link them and do a
filtered search to bring up only the catering records which have the same
[Course ID] as on the previous form.
When there is no existing record I need the form to open up to a new record
automatically entering the [Course ID] of the preceding form.