Using criteria in multiple queries

[camiller]

Hi,

I have several queries that I need to run one right after the other. Three of the queries require a date input that I have set through a criteria. Each one requires the same date. Is there a way to enter the date once and have it be used with each of the queries?

Thanks, Camiller

 

[cmmrfrds]

In Standard Module.
Public datevar as date

Public Function ReturnDate() as Date
ReturnDate = datevar
End Function

In your queries.
select * from tab where mydate = ReturnDate()

In your Form in afterupdateevent of the date text field
datevar = Me.Txtdate

execute the queries.