Newbie question, how to use variables in query

[Ben2k]

Hi,

Quite new to access 2000, first project

I have a form where I have put two labels and two text boxes

label1, label2, text1, text2

I want users to enter a start date in text 1 and an end date in text 2

I also have a command button, when this is pressed I want to use the values of text 1 and 2 as parameters in a query

i.e. Between text1 and text2

How do I do it?

Thanks

Ben

 

[SydneyGeek]

Go to the query, in Design view.

In the Criteria row below the date field that you want to filter, type

Between "#" & Forms![YourSearchForm]![TheFirstDateField] & "#" and "#" & Forms![YourSearchForm]![TheSecondDateField] & "#"

The "#" bits are to tell Access that you are working with dates. Adjust names to suit.

If the command button on the form already opens the form, great. Otherwise delete it, turn the Control Wizard on (the wand thingy on the Toolbox), drag another command button onto the form, and follow the prompts.

Denis