query variables

  • Thread starter Thread starter Vsn
  • Start date Start date
V

Vsn

Hello all,

I do have a problem populating variables in a query.

In query design view, from the record source of a Form, I did put to
variables [StartDate] and [EndDate]. Now when I run the query or form boxes
popup to ask for the value of the 2 variables. If I fill them in all works
fine. But I would like to populate the values before the boxes popup.

How can I do this from an other form or from the form code by using declared
variables.

Thanks for any suggestions.
Ludovic
 
select * from tablename where fieldname between forms!formname!control1name
and forms!formanme!control2name
 
Back
Top