Hi,

I'm creating a macro that ties in several update, append & make table queries all into 1 action.
The update queries are adding a date to an exiting table.

Is it possible to have the macro prompt me to enter the date for the update query?

thanks
Jamez

Not sure about doing this in a macro, as I never use 'em, but... one option I've used a LOT is to create an unbound form with a textbox formatted per my needs (in your case as a [long/short/general] date). Then put a button on the form that executes your update query.

DBEngine(0)(0).Execute "your update query"

Yes. You can use a Parameter to prompt for the value to be used in the update. When the OpenQuery Macro action is executed, Access will prompt for the Parameter value.