Open form from double click on field

[RexesOperator]

I have a form frmTowerLog with a text box called txtFILENUMBER. When I double click on it this code fires (thanks to Paul's site):

Private Sub txtFILENUMBER_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmTransactionsMain", , , "txtFILENUMBER = '" & Me.txtFILENUMBER & "'"
End Sub

However it brings up a parameter query asking for the File Number. How can I go directily to the frmTransactionsMain without being asked for the file number?

 

[boblarson]

You need to feed it the FIELD not the text box:

DoCmd.OpenForm "frmTransactionsMain", , , "[FILENUMBER] = '" & Me.txtFILENUMBER & "'"

And if FileNumber isn't your field name in the form that is opening, replace it with the real field name. Also, if it isn't text then use this instead:

DoCmd.OpenForm "frmTransactionsMain", , , "[FILENUMBER] =" & Me.txtFILENUMBER

 

[RexesOperator]

Thanks again Bob - works perfectly!