A
Airkon
I have a problem trying to figure this out and here is the scenario...
Form A - Query A
Form B - No Underlying Query
Form B Subform 1 - Query B
Form B Subform 2 - Query C
I have 2 subforms inside Form B using a tab control.
When I have chosen a ID inside Form A and clicked a command button for data
entry, Form B is opened. If the ID exist in Table B and Table C, I want the
subforms to go to the record, if not, make a new record.
How do I go about doing searching and where do I code it? Thanks in advance.
Form A - Query A
Form B - No Underlying Query
Form B Subform 1 - Query B
Form B Subform 2 - Query C
I have 2 subforms inside Form B using a tab control.
When I have chosen a ID inside Form A and clicked a command button for data
entry, Form B is opened. If the ID exist in Table B and Table C, I want the
subforms to go to the record, if not, make a new record.
How do I go about doing searching and where do I code it? Thanks in advance.