Hi,
I have a form that captures data inputted into a text field and a couple of drop down menus. This runs a query and outputs the results to a form.
What I am trying to achieve is to monitor what is inputted into the search form.
When I hit search a macro is run which opens a form that runs a query and also an Append query.
e.g
The user selects a product from the drop down menu and any records that have the chosen product will be displayed and the Append query will add the details into a table. All this works but I am having problems filtering the data that goes into the table.
If a user only selects an item from the product combo box I want the Append query to reflect this in the form, thus leaving the Department and keyword fields blank. Currently the append will fill all fields regardless of what has been chosen in the search form.
So for example, if a user leaves the Department and Products blank and inputs say "New Account" in the keyword search field the Append will only add the keyword that was inputted, although in the Keyword field of the table that is being search contains a lot more keywords than "New Account".
I tried specifying the Textbox data in the criteria but when i do this the append doesn't work?
I will gladly send a sample database to anyone that may be able to help if you don't understand, Zipped it's about 500k
Thanks in advance
Tezdread
I have a form that captures data inputted into a text field and a couple of drop down menus. This runs a query and outputs the results to a form.
What I am trying to achieve is to monitor what is inputted into the search form.
When I hit search a macro is run which opens a form that runs a query and also an Append query.
e.g
The user selects a product from the drop down menu and any records that have the chosen product will be displayed and the Append query will add the details into a table. All this works but I am having problems filtering the data that goes into the table.
If a user only selects an item from the product combo box I want the Append query to reflect this in the form, thus leaving the Department and keyword fields blank. Currently the append will fill all fields regardless of what has been chosen in the search form.
So for example, if a user leaves the Department and Products blank and inputs say "New Account" in the keyword search field the Append will only add the keyword that was inputted, although in the Keyword field of the table that is being search contains a lot more keywords than "New Account".
I tried specifying the Textbox data in the criteria but when i do this the append doesn't work?
I will gladly send a sample database to anyone that may be able to help if you don't understand, Zipped it's about 500k
Thanks in advance
Tezdread
