Form event

  • Thread starter Thread starter newkid
  • Start date Start date
N

newkid

HI All
I have some delete queries and an import in VBA code. I want to
intitialize the queries and import when a form opens. The form is
based on a table that is updated with the queries and import.

Problem: When I import the data and run the queries my form comes up
blank. I think I just need to put it on the correct event but I
haven't been able to find it. I've tried refreshing and requering the
form after the import which didn't work.

Thanks
 
Strange... Does the form have a recordsource? I assume you check that the
table does have any records. Normally you don't have to refresh anything if
the query ran before opening the form because by then the table has been
updated already so the form should present you with a recordset.

Can you give some more details on how the form is presented and how the
query runs?

Maurice
 
Back
Top