There was a problem accessing a property or method of the OLE Object
Just started playing with ADP. Normally I'd build a From that has a selection criteria and shows some specifics about a set of rows, the user then selects the row and clicks a button to see the details. I get the error mentioned above though.
The code is listed below. Any ideas? Is this An Access thing or a sql server thing?
Private Sub Command22_Click()
On Error GoTo Err_Command22_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Case"
stLinkCriteria = "[CaseId]=" & Me![CaseId]
DoCmd.OpenForm stDocName, , , stLinkCriteria