If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Useing A combo Box to Select a record then displaying details
Sorry for the elementary question.
I have a table of clubs. I have used an unbound combo box to select a name from the table. How do I then display the information from that club? Regards Mike ABbott. |
#2
|
|||
|
|||
Useing A combo Box to Select a record then displaying details
Use a bound form, and the AfterUpdate event procedure of the unbound combo
finds the record. Example in: Using a Combo Box to Find Records at: http://allenbrowne.com/ser-03.html -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Mike the bass" Mike the wrote in message ... Sorry for the elementary question. I have a table of clubs. I have used an unbound combo box to select a name from the table. How do I then display the information from that club? Regards Mike ABbott. |
#3
|
|||
|
|||
Useing A combo Box to Select a record then displaying details
If Allen's example from the his site is a little too deep for you, Mike, you
can let Access' Combobox Wizard do most of the work for you. First you must have your form set up to display the record you want to retrieve, i.e. you must have controls set up with the appropriate Control Sources to bind them to the fields you want displayed. Then simply: Add a combo box to your form. The Combobox Wizard will pop up Select "Find a record based on the value I selected in my combobox." Hit Next. From the same query as the form is based on, click on the field you're searching by to move it to the right side. 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 item to search by, or you can start to enter the item, and the combobox will "autofill" as you type. Hit Enter and the record will be retrieved. -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200612/1 |
Thread Tools | |
Display Modes | |
|
|