Wait for form load then have VBA trigger a button.

IT WORKED!!!!

Thank You Thank You Thank You!!!!!!!


Jeanette Cunningham wrote:
Here is one suggestion (untested):

1.Try using a separate form with a button.
Open form with button.
On its current event,
-Put code to open the form with the queries.
-Then a call to DoEvents (just DoEvents on one line).
-Then a call to the code on the form with queries, that creates the pdf.

If that doesn't help, try using WithEvents to tell the form with the button
that the form with the queries has finished loading.
See help for WithEvents.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Ok, I am having a hard time with this. Access 2007 I have a button that
takes an image of the form and makes it a pdf. Now I need to automate
[quoted text clipped - 18 lines]
information
for user to change info if necessary.

--
Message posted via http://www.accessmonster.com