I have a database that lists facilities and their contact information by an id number. I created a query that allows one to enter the id# or the system name to get the rest of the information. They way the query was created only shows one entry box at a time. In other words, the uses is prompted to enter the id#, once entered, or left blank and OK is hit, the next prompt for the name comes up. I tried to create a form using this query, but get the same response. I do not want the prompt boxes to pop up individually, I want tboth boxes to be visible at the same time on the form to give the user the ability to quickly choose which query option they want. can anyone help?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Query Form
- Thread starter todd8
- Start date
- Thread starter
- #2
I know the first post I left is probably very confusing. I will try to reword. I have a database of facilities and contact information, each facility having it's own unique id #. I want to create a form with two boxes where the user can either type in the id# or system name, and have all pertainent information returned. I have created a query to do this, but it prompts the user for the id#, then the name. I want both displayed at the same time, giving the user the ability which they want to use to get the data.
Hope this is clearer.
Hope this is clearer.
missinglinq
Programmer
Todd8,
All you have to do is place two combo boxes on the form using the Combo box Wizard. Place the box on the form, Select "Find a record on my form based on the value I selected". Click OK then double click on the ID# to move it to the right. Click finish.
Repeat this choosing your system name field for the second combo box. Then your users can either drop down the box and scroll thru the possibilities or they can start to type and the box will autofill.
Hope this helps!
The Missinglinq
There's ALWAYS more than one way to skin a cat!
All you have to do is place two combo boxes on the form using the Combo box Wizard. Place the box on the form, Select "Find a record on my form based on the value I selected". Click OK then double click on the ID# to move it to the right. Click finish.
Repeat this choosing your system name field for the second combo box. Then your users can either drop down the box and scroll thru the possibilities or they can start to type and the box will autofill.
Hope this helps!
The Missinglinq
There's ALWAYS more than one way to skin a cat!
missinglinq
Programmer
Todd8,
In looking at your posts again, I realized that you have (I think) created a query specifically to look for records with ID# and System name as criteria. My answer above is assuming your query is the Control Source for your form. Redo your query so that it returns all the records in your DB, make it the Control Source for form, and the combo boxes I outlined above will do the job! The Combo Box Wizard actually writes its own query to do the search.
The Missinglinq
There's ALWAYS more than one way to skin a cat!
In looking at your posts again, I realized that you have (I think) created a query specifically to look for records with ID# and System name as criteria. My answer above is assuming your query is the Control Source for your form. Redo your query so that it returns all the records in your DB, make it the Control Source for form, and the combo boxes I outlined above will do the job! The Combo Box Wizard actually writes its own query to do the search.
The Missinglinq
There's ALWAYS more than one way to skin a cat!
- Status
Similar threads
