Double Click for Open Form Failed

[Dalan]

I probably just need a simple piece of code to do this as the couple
tried so far have failed. I created a new Access 97 Form Filter
(frmFilterForm) which displays most of the key data fields from the
main form (frmMain) records. What I'm trying to do is simply double
click on an autonumber ID column record in frmFilterForm and have it
to open the related record in frmMain for updates. Any assistance will
be appreciated. Thanks.

[Rick Brandt]

"Dalan" <ot***@safe-mail.net> wrote in message
news:50**************************@posting.google.c om...

I probably just need a simple piece of code to do this as the couple
tried so far have failed. I created a new Access 97 Form Filter
(frmFilterForm) which displays most of the key data fields from the
main form (frmMain) records. What I'm trying to do is simply double
click on an autonumber ID column record in frmFilterForm and have it
to open the related record in frmMain for updates. Any assistance will
be appreciated. Thanks.

One of the wizard options when you drop a new command button on a form does exactly
this. Run that and then copy the code from the resulting button to the Double-Click
event of your control. It will look something like...

DoCmd.OpenForm "YourFormName",,,"[ID] = " & Me![ID]