Hi all,
I just don't understand why it's not working...
Few details:
MsgBox shows that the ID it pulls is correct, but the form opens in empty, or add? mode. (fldIQAID shows "(New)" and form is blank)
Neither of my forms are in Data entry mode. Data Entry = No
I tried DoCmd.OpenForm "frmIQA", , , "fldIQAID = " & Me.fldIQAID
DoCmd.OpenForm "frmIQA", , , "fldIQAID = #" & Me.fldIQAID & "#"
DoCmd.OpenForm "frmIQA", , , '"fldIQAID = " & Me.fldIQAID & "'"
Any ideas?
I just don't understand why it's not working...
Code:
Private Sub fldIQAID_DblClick(Cancel As Integer)
DoCmd.OpenForm "frmIQA", , , "fldIQAID = " & Me.fldIQAID
MsgBox "Your ID is " & fldIQAID & ""
End Sub
Few details:
MsgBox shows that the ID it pulls is correct, but the form opens in empty, or add? mode. (fldIQAID shows "(New)" and form is blank)
Neither of my forms are in Data entry mode. Data Entry = No
I tried DoCmd.OpenForm "frmIQA", , , "fldIQAID = " & Me.fldIQAID
DoCmd.OpenForm "frmIQA", , , "fldIQAID = #" & Me.fldIQAID & "#"
DoCmd.OpenForm "frmIQA", , , '"fldIQAID = " & Me.fldIQAID & "'"
Any ideas?