Useing A combo Box to Select a record then displaying details

[Guest]

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.

 

[Allen Browne]

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

 

[missinglinq via AccessMonster.com]

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