Hello Everybody,
I have attached a sample database.
Basically I am trying to make the form combo box select only one field and hide all the others when the query is run, and the text box filter the results of the records of the selected fields: return all records equal or greater than the input number.
For example: a user run the form, select windshield, input 66 and run the query, the query should return:
Vehicle | Windshield
Chrysler | 87
Volvo | 66
I would really appreciate if you could have a look in this small database and give me a hand, I will surely learn a lot in the process.
Many thanks,
I have attached a sample database.
Basically I am trying to make the form combo box select only one field and hide all the others when the query is run, and the text box filter the results of the records of the selected fields: return all records equal or greater than the input number.
For example: a user run the form, select windshield, input 66 and run the query, the query should return:
Vehicle | Windshield
Chrysler | 87
Volvo | 66
I would really appreciate if you could have a look in this small database and give me a hand, I will surely learn a lot in the process.
Many thanks,
