Criteria filter

[nashr1928]

I am using access 2003 and wish to add a search text field with a button to launch the query being filtered. The query name is Billing. I found this example online but cant seem to get it to work on my database. like "*" & [forms]![entries]![textcriteria] & "*"



What do I use for control source in the text field? As it is If I click on the button then it pops up a new window with text field to enter the data to be filtered. I want to use the field That I put on the form to add data not the window that pops up.

[aytee111]

If I have understood correctly: You have a field on a form where you enter data and you want a query to run that matches that data?

What type of data does the textbox contain? The criteria string you have above works well with partial entries, such as names, where the person wants John and Johnny and Johnson, etc, so enters "John" and all three records will be selected. You don't use that for dates or numbers or fully entered items.

That criteria line should work in the query, I'm not sure why it isn't working.

[nashr1928]

I have added a couple of attachments. It shows the automatic window that pops up when you launch the query with the button. If you leave it blank and enter then you get the full query view. If I enter anything in that text field window then I get a blank query with no data as you can see on the attachment. I want to be able to enter 2011 and ony get those records for that year or I want to enter the customer names or the instrument names and just get those records.

[aytee111]

In your "Like" statement there is an error and the query cannot find the field you are referring to. Either the form is closed or else there is a spelling mistake - that is not the name of the form or that is not the name of the textbox. They have to match exactly otherwise the query cannot find it.

If you are matching on Year then you do not use "Like", it will be equal to. The query field will be "xxname: Format(datefieldname,"yyyy")" and in the criteria you will put the form text box name with an equal sign (no quotes). Each of the fields mentioned above will either need its own query or else the one query needs to have "OR" criteria for each field - if date is equal or customer or... whatever. I don't know exactly how you want this to happen.

[nashr1928]

Well you have convinced me its more complex that I had thought. Um right now I'm using filter by selection from the form and it works well. I just wanted to try and put the execution on the form as a button instead of using a tool selection. Thank you for educating me on this subject.