More than one action in a form's 'On Open' property?

M

Mike Webb

Using Access 2K2.

I am heavily using a sample db from an MVP named Roger Carlson, specifically
his "frmFilterForm".

The 'On Open' property of the form is:

Private Sub Form_Open(Cancel As Integer)
Me.Filter = ""
End Sub

I have a Make Table query I need to run to create the source table
(tblQuery) for this form. It combines the desired fields from my 3 base
tables (one of which is a join/junction table). I wrote a simple macro that
I think will help this. It opens the Make Table query, echo is set to OFF
and then closes the query.

How do I add this in the code? I tried to add "DoCmd.RunMacro
"macroFormOnOpen" ", but I got an Action Failed dialog window and when I
clicked debug, this line was highlighted.

TIA,
Mike
 
D

Dan Artuso

Hi,
Why do need to create a table?
Can you not just base your form on a query that pulls the desired info?
 
M

Mike Webb

Good answer. Guess I didn't think it through. I have another form that
needs this table (or data); guess I just couldn't see the forest for the
trees.

Thanks for the insight.
Mike
 

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

Top