How are the filters applied? Are you using parameters in your query that point to your form? It would be more flexible to not use parameters - write a bit of code to build a filter string, then apply the filter when you open the form bound to the data you want to display. If you do that, you can replace your batch/serial number combo with an unbound text box where the user can enter either criteria. Or, you could provide two combo boxes - one that lists valid batch numbers, and the second that lists (perhaps filtered by the chosen batch) all serial numbers. You would use the LIKE predicate in your filter string to search for just a part of the value.
Give me some more details - like the names of the combo boxes, their Row Sources, the name of the filtered form you want to open, and the names of the three filter fields. Also, how is the batch number formatted - that is, what part is the batch, and what part is the serial?
John Viescas, Author
SQL Queries for Mere Mortals
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
On Nov 16, 2016, at 11:13 AM, firstname.lastname@example.org [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Posted by: John Viescas <email@example.com>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (2)|
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.