Displaying selected record in a form for editing

[Lyn from Edinburgh]

I want to be able to use a form to edit a selected record. How can I display
all the fields of a record selected by its unique id in a predesigned form. I
feel this should be so simple but I am missing the point somewhere.

 

[StCyrM]

Hi Lyn

The following command line will allow you to open a scondary form based on the
ID.

Of course your form name and the ID will have to be adjusted to match what you
have.

DoCmd.OpenForm "frmDetails", _
WhereCondition:="RecordID=" & Me.RecordID


Best Regards

Maurice St-Cyr
Micro Systems Consultants, Inc.