Using Forms to search a table

[djrock]

Hello i need help on how to put a box of sum sort in a form to be able to search a field in my table whats every typed in and without this box changing whats stored on the table.

I want a user to be able to enter a price in and it finds hotels in that price range.

Thanks

 

[DJ_DEF_CON_1]

I assume you have a table with a low price range and a high price range.

 

[djrock]

I have a price range from £31.52 up to £180.67

 

[DJ_DEF_CON_1]

Why don't you put a text box in the form that isn't bound to anything. I would then run a query off the text box looking for related records.

 

[djrock]

But how will that query get the data from the user to find a price or the closest match

 

[djrock]

Can anyone help? I don't have much time left to finish the database and microsofts help is not very good.

Thankyou

 

[Rich]

Set the criteria of the Price field in the query to >=[EnterLowestAmount] And <=[EnterHighestAmount]

 

[djrock]

i need to some how have that in my form to allow the user to enter a price and for the form to go get that price range.

Example if the user enters £50 it will get everything thats £50.00 £50.99 or from £50 to £60.

Will that if the user enters that a price finds price they want and allow them to go through all the hotels at that price.

 

[Rich]

Try the query as posted first to make sure it's returning the results you would expect, then just add the Forms!MyForm!MyTextBox references to the criteria

 

[djrock]

The query working fine but the Forms!MyForm!MyTextBox i don't know where to put it i tried it in the query criteria but i did not worked.