Dbl Click to Open Form

  • Thread starter Thread starter TeeSee
  • Start date Start date
T

TeeSee

What am I missing? Do I have the syntax correct?
Is there something required in the filter property of the form to be
opened?

The field [FileNumber] is the field on frmSearch to be double clicked.
[ctlFileNumber] is on the form being opened.


Private Sub FileNumber_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmMSDSdataInput", acEdit, , "ctlFileNumber=forms!
[frmSearch]![FileNumber]"
End Sub

Suggestions appreciated as always. Regards.
 
What am I missing? Do I have the syntax correct?
Is there something required in the filter property of the form to be
opened?

The field [FileNumber] is the field on frmSearch to be double clicked.
[ctlFileNumber] is on the form being opened.

Private Sub FileNumber_DblClick(Cancel As Integer)
    DoCmd.OpenForm "frmMSDSdataInput", acNormal, , "ctlFileNumber=forms!
[frmSearch]![FileNumber]"
End Sub

Suggestions appreciated as always. Regards.
Click to expand...

Sorry ... The form shd open acNormal. I am trying to show data for
edit.
 
Back
Top