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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OpenForm vs. Form menu double click. 3
Filter main form to records with no related records in subform,maintain updateable recordset 4
Filter not re-activating 0
Dynamically Setting a forms Input Parameter Property 2
Using ADO recordset as combo box row source gives "id is invalid" 1
if recordset is empty, add new record (repost) 11
ADO Form bind 4
Recordset Problem 5

Top