Judo Club database...help needed

[Guest]

I have done really well so far with limited knowledge and without help but
now I am stuck.
I am putting together a database for all our members details.
I have all the details at the top of the form and everything works great.
I would like a table at the bottom containing name and address so we can
scroll down it and pick a member so that when we click on it their details
are brought up at the top.

I know this is really easy but I just cant do it

HELP!!!!!!!!!!!!!!

 

[Van T. Dinh]

You may want to use a ListBox in the Form Footer and use the ListBox_Click
Event to change the Current Record of your Form.

Check Access Help on the ListBox.

 

[Guest]

Cant seem to get my head round the click on event bit.

I have created the list box

 

[Van T. Dinh]

You will need to use the Form's RecordsetClone to navigate to the required
Record.

I normally use the ComboBox in the FormHeader and you can use the ComboBox
Wizard to create the "navigation" ComboBox with code for you.

Try the ComboBox Wizard and if you still want to use the ListBox, copy (and
slightly modify) the code from the ComboBox created by the Wizard.