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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Select in Combo Box or List Box and after select it will fill form
- Thread starter chouna
- Start date
missinglinq
Programmer
Just answered this in response to another posting this morninng. Glad I saved it!First you must have your form set up to display the record you want to retrieve, i.e. you must have fields set up with the appropriate Control Sources. Then simply:
Add a combo box (not a listbox)to your form. The Combobox Wizard will pop up
Select "Find a record based on the value I selected in my combobox." Hit Next.
Click on the field you're searching by to move it to the right hand "fields" box. Hit Next.
Size the column appropriately. Hit Next.
Name the combobox. Hit Finish.
Now you can drop the combobox down and scroll down to the number to search by, or you can start to enter the number, and the combobox will "autofill" as you type. Hit <Enter> and the record will be retrieved.
The Missinglinq
There's ALWAYS more than one way to skin a cat!
Add a combo box (not a listbox)to your form. The Combobox Wizard will pop up
Select "Find a record based on the value I selected in my combobox." Hit Next.
Click on the field you're searching by to move it to the right hand "fields" box. Hit Next.
Size the column appropriately. Hit Next.
Name the combobox. Hit Finish.
Now you can drop the combobox down and scroll down to the number to search by, or you can start to enter the number, and the combobox will "autofill" as you type. Hit <Enter> and the record will be retrieved.
The Missinglinq
There's ALWAYS more than one way to skin a cat!
- Status
Similar threads
