Need an index for forms

[ArthurRW]

I have 200+ personnel records, I do my updates on a form for each record.
Right now I scroll through the records until I find the one I need to update,
I want to have a list of names that when clicked on will bring up the form
with that particular record of information on it for updating. I figure I
need a table or query and a macro to bring up the record in form view but
I've never done this. Ideas or locations for this information will be
appreciated.

 

[Dirk Goldgar]

I have 200+ personnel records, I do my updates on a form for each record.
Right now I scroll through the records until I find the one I need to
update,
I want to have a list of names that when clicked on will bring up the form
with that particular record of information on it for updating. I figure I
need a table or query and a macro to bring up the record in form view but
I've never done this. Ideas or locations for this information will be
appreciated.

Probably the easiest way to set this up is to use the Combo Box Wizard to
add a combo box to your form, maybe in the form header, and tell the wizard
to build you a combo box that will "find a record on my form". That's one
of the choices that the combo box offers.

 

[ArthurRW]

Thanks, works fine,once I figured out the trick to opening the wizard