doubleclicking record in subform opening new form

Hello.

I've got an Access 2000 database based heavily on the Contacts database
template provided with Access. What I would like to be able to do is list
the contents of the contacts table (sorted by last name) in a form, then
when clicking on the record I want to edit, opening the input form with the
data for that record loaded. I'm sure there is a way to do this, I just
can't seem to figure out how.

Hopefully this makes sense.

Thanks to all for your input.

CS

On Click Event or on Double Click Event of the form, type the following line
DoCmd.OpenForm "formName", acNormal, [filterName], [wherecondition]

br

"CS" wrote:

Hello.

I've got an Access 2000 database based heavily on the Contacts database
template provided with Access. What I would like to be able to do is list
the contents of the contacts table (sorted by last name) in a form, then
when clicking on the record I want to edit, opening the input form with the
data for that record loaded. I'm sure there is a way to do this, I just
can't seem to figure out how.

Hopefully this makes sense.

Thanks to all for your input.

CS