Need an index for forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ArthurRW - 14 Jan 2008 03:20 GMT

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.

Reply to this Message

Dirk Goldgar - 14 Jan 2008 03:28 GMT

>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
[quoted text clipped - 4 lines]
> 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.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message

ArthurRW - 15 Jan 2008 21:45 GMT

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

> >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
[quoted text clipped - 9 lines]
> 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.

Reply to this Message