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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Passing a Date Variable from Code to Update Query in a Loop 7
Subform and variable 2
Between date and date query do not show values, how change this? 6
Query with variable 4
Problem with 1 Query with Criteria feeding another query 3
Parameter Query 2
Using a Variable as a query Expression Value 2
VBA: How can I use a string variable as autofilter criteria? 4

Back
Top