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.

On Mon, 7 Jan 2008 15:55:01 -0800, ArthurRW wrote:

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

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.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail