By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,829 Members | 673 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,829 IT Pros & Developers. It's quick & easy.

Double Click for Open Form Failed

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"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]
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.