Two text boxes in a form to query values in Between X to Y

[LightingMitten]

Hi. I am trying to set up a form with two text boxes so I can run a query that searches for records with values between a two numbers. I have set up 2 text boxes in the form design, they are named AvgAmt0 and AvgAmt2.

In the query design view I was able to produce the desired results by placing the following in the criteria statement of the field titled "Amount":

Between 10 And 50

Because this worked I tried to use the following to have the query reference the two text boxes on my form:

Between [Forms]![Search]![AvgAmtO] And [Forms]![Search]![AvgAmt2]

but this doesn't work, when I run the query I got the whole range from the Amount field from 1 to 10,000. Does anyone know how to do this?

 

[Alansidman]

Please read this: http://www.excelguru.ca/content.php?184

cross posted at: http://www.accessforums.net/forms/using-two-text-boxes-form-query-between-31630.html