query criteria from text box in form

[Spelthorne1]

Have set up a db that contains the date when data was inputted such as 16/02/2004.

Having this, we require a query that can grab all records between certain dates. But the problem is, we want to type in the appropriate dates in a text box on a form where a button will be pressed and a new table will be created.

Is it possible to allow the 'criteria' to take text from the text boxes?

Eg; between #15/02/2004# And #16/02/2004#
Instead of the dates, we want

'between form1.txtbox1.text and form1.txtbox2.text'

Thanks,
If this doesnt make any sense, i'll try and word it better!!

 

[Mile-O]

between form1.txtbox1.text and form1.txtbox2.text

Almost there:

Between [Forms]![Form1]![txtbox1] And [Forms]![Form1]![txtbox2]

 

[Mile-O]

You might want to have a look at searching for one of my calendar examples - nice for setting date ranges.

 

[Spelthorne1]

Thanks,

Ive copied

Between [Forms]![Form1]![txtbox1] And [Forms]![Form1]![txtbox2]

into the criteria box but nothing happens? I just get a blank table with no data in it.
Any suggestions?

 

[Spelthorne1]

I hit the wrong button!
it works

thanks

 

[dcx693]

Is your form actually named "form1" and your textboxes actually named "txtbox1" and "txtbox2"?

 

[Spelthorne1]

yep!

Im working on a test database before calling them properly!