Hi JoeM,
Yes. I have tried to build a form named "frmTapeHistory" that has "qryTapeHistory" as a data source.
And I wrote
Code:
Private Sub cmdOpenFrmTapeHistory_Click()
DoCmd.OpenForm "frmTapeHistory", , , , acFormReadOnly, acDialog
End Sub
to open the form. (the command button's on click event is in the main form "frmTape")
But the form intentionally defaulted in Datasheet view is blank.
I think the problem is the query "qryTapeHistory" which has the criteria
"=[Forms]![frmTape]![txtTapeID]" in the "TapeID" field on QBE grid.
I think that the criteria is wrong.
The query does not link with the TapeID that I want to see.
And I don't know how to write to link it.
Please excuse me. I am a beginner.