Re: Any Microsoft Access guru's out here....
Posted 7/19/2007 1:01:56 PM 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....
|