Useing A combo Box to Select a record then displaying details

M

Mike the bass

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.
 
M

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.
 
Top