Form_Open with emtpy recordset

C

chemicals

I have a continuous form that is opened with a Filter (i.e. CONTRACT=123).
This works fine.

However, if there are no records returned I want to be able to execute an
Append Query to populate the bound table with records from another table and
then display them.

If I do everything in the Form_Open event handler I probably don't need to
pass any filter args to the OpenForm method but I am not sure how to do
this...
 
Top