parameter query

[Lapchien]

I have 2 queries, 1 produces a list of direct debit payments, the other then
'marks' those records as processed. The parameter is a date (usually
today's date). I run these 2 queries from a macro. Is it possible to be
able to enter the date parameter just once when the macro is run..?

Thanks,
Lap

[Tom van Stiphout]

On Mon, 15 Dec 2003 09:29:18 -0000, "Lapchien" <no**@m.com> wrote:

No.
One alternative is to put the parameter on a form. User enters date in
textbox and clicks the Preview button, your queries "look back" at
that date field:
.... where ProcessDate = Forms!frmMyForm!txtProcessDate

-Tom.

I have 2 queries, 1 produces a list of direct debit payments, the other then
'marks' those records as processed. The parameter is a date (usually
today's date). I run these 2 queries from a macro. Is it possible to be
able to enter the date parameter just once when the macro is run..?

Thanks,
Lap