Criteria to look up a field.

[BenjaminTheBlue]

Nearly finished my 1st database thanks to the people here.
Just need direction on one more thing:-

i need to input a "return date" into a field on a form and then click a button to run a query based on that date field to list all carts to return on that date. We always have to put in different dates and so 1 set query would be no good.
I assume i need some kind of criteria in the query. Anyone help?

Many Thanks Ben

 

[pdx_man]

This has been covered many times, so if you don't understand my answer, do some searches.

Have the criteria point to the control on the form:
=forms!formname!textboxname

 

[BiffBojangles]

I have a similar problem and can't seem to figure it out. A height is entered into a form. I have a table that has the the following fields ... ID,50,51,52...100, 101, etc (numbers are the height values). There is a number assigned to each of the height and IDcombinations. IDis set is my primary key because it is unique and depending on what height value is entered onto the form determines the FACTOR. Based upon the ID (which is known) and the height (which is entered into the form) I need to access the record value corresponding to the ID and Height combinations (in this case the FACTOR). Can someone help? Thanks in advance