Displaying selected record in a form for editing

  • Thread starter Lyn from Edinburgh
  • Start date
L

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

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