G
Gareth Grimshaw
I have built a query that has about 8 searchable fields on it
For example if someone wants to build a new query that selects all records from New York and new query window opens with just that set. This i can do not a problem. However if there are 5 different search criteria how do i do it? The trouble i am having is i cannot forsee what records are going to be filtered! so i cannot put a criteria to equal what ever a drop down box contains on a form as the user might not select it So if a user does not select a filter for a given item then the query will know to return all the values
I have done this in Visual Basic before, but want the output to be like a normal query in access. As it will be querying a query and want the event to create a "virtual" query
Many thanks in advance
Gareth
For example if someone wants to build a new query that selects all records from New York and new query window opens with just that set. This i can do not a problem. However if there are 5 different search criteria how do i do it? The trouble i am having is i cannot forsee what records are going to be filtered! so i cannot put a criteria to equal what ever a drop down box contains on a form as the user might not select it So if a user does not select a filter for a given item then the query will know to return all the values
I have done this in Visual Basic before, but want the output to be like a normal query in access. As it will be querying a query and want the event to create a "virtual" query
Many thanks in advance
Gareth