Macros

[HelsBels]

Hello

I have set up a macro that will run several queries that I have in my database. I also have a form set up. At the top of the form I have a text box where you enter the date that you want to select data for. This is referenced in to each query - so that you need to enter a date in the form for the queries to work (or you will be prompted for a date if you don't use the form). If I set up a macro to run each query, how do I get it to prompt me for the date for each query? I just tried to run the macro and even though I have entered the date on to the form, it won't bring me any data back.

 

[GumbyD]

OK - in your query criteria I am guessing that you have an iif statement that looks something like the following:

iif(isnull(forms![YourFormName]![YourFieldName]),[Enter Date],forms![YourFormName]![YourFieldName])

If not then you need something like that to prompt only if the form value is null. Make sure in the Macro that you are not setting the warnings to false or you will not get the message boxes.

Good Luck

GumbyD