combo selectio on user form

[NMShadey]

combo selection on user form

Hey, I'm a student at some college in South Wales currently studying I.T. we are undergoing a Database Unit in which we have to set up a database on any given topic. I have chosen this to be on a book store using 3 tables.

Anyhow I have quite little knowledge with Access and have been pulling my hair out in trying to figure out the following problem.

I have a table called "Members" that has the primary key "MemberID". I have set up a form that displays all the fields from this table. Next I wanted a drop down list (which i have created) that lists all the Member ID's from the table; this is the part i can't figure out, when a selection is made how do I get all the other fields to update the information based on the selection from the drop down list.

Many thanks for any help

 

[Carmen]

It sounds like you want to add a Combo Box to your form using the Wizard, and when you get to the screen that asks what you want the combo box to do, choose Option 3 which says something like "Find a Record on my Form based on the selection in my Combo Box" and follow the rest of the instructions on the wizard. That should do what you want.