How do I bring up the correct record ?

A

ArthurRW

I have a club database with over 225 records. I want to be able to open
individual records in "form" for updatinig by creating an index where
clicking on a name will open up the form with that individual's information
on it. If it requires a macro please go slowly, I've never done one before. I
already have my form, I just don't want to scroll through all those records.
 
F

fredg

I have a club database with over 225 records. I want to be able to open
individual records in "form" for updatinig by creating an index where
clicking on a name will open up the form with that individual's information
on it. If it requires a macro please go slowly, I've never done one before. I
already have my form, I just don't want to scroll through all those records.
Click to expand...

Add a Combo Box to your existing form (the form IS bound to the
members table, isn't it?)..
Place it in the Form's Form Header section.
Use the Combo Box Wizard when adding the combo box.
Select the 3rd option on the first page of questions, something like
"Find a record ...etc.
Follow the instructions.
When done, finding a members ID in the combo box will cause that
member's records to appear.
 
Top