Re: Any Microsoft Access guru's out here....
Posted 7/19/2007 2:14:15 PM by LSP2005


Posted by luvsun27


Posted by LSP2005

According to my DH macros can ask for input but unfortunately he thinks you need to design it a different way. Either have the person fill out the form first or have the macro end, the person fills out form and a new macro begins when the form is completed. If necessary, have the first macro pass arguments with hidden fields on the form to the new macro.



Hmm...that's what I was afraid of. I have a query that creates a table, and I want to update this new table with the user input. I really can't have the user do the imput first, because the table doesn't exist. Grrrr....



No problem, DH sticks by his first response, put the second half the instructions you need in your second macro that is triggered by the close event of the form.

Example:

Macro A

Creates Table
Opens form


Macro B

Starts when form is closed
...
...



Print Post      Close Window