showing result on form using criteria

[rehanemis]

Hi,

I have created a form using query. I would like to show the form records based on the text value. Basically wants to filter the records as:

When I put 20 in text Box in form it shows records where values are less than or equal to 20.

Waiting of your kind reply.

Thanks

 

[sneuberg]

Let's say the textbox has the name NameOfTextbox and the form has the name NameOfForm and the field has the name NameOfField, then in the record source query of the form in the criteria for NameOfField put

<=Forms![NameOfForm]![NameOfTextbox]

Something will have to requery the form, so in the afterupdate event of the textbox or on click event code of a button you will need to put

Me.Requery

 

[rehanemis]

Thanks but I don't want to input the criteria in the query design criteria. I first would like to view all records in form if I put 20 then it shows the records where value in a field if equal to 20 or less than 20.

 

[sneuberg]

I guess I don't understand what you have and what you want. Could you upload your database so I can see what you have so far.