I have a bookmark issue that I can't solve on a MS Access 2013/Windows 7/MySQL back end set up.
When I start the application it loads a form with client data and there is a subform showing details of quotations for those clients.
I'm trying to access the first quotation for the selected client by setting a bookmark on the subform but I'm getting a Run-time error '2766': The object doesn't contain the Automation object '|' - the bar character may be a clue perhaps?
It's failing on line 170 in the code below, so the quotation has been found by the ".findfirst" action
110 With Form_frmGrpMbrs.RecordsetClone
120 If .RecordCount <> 0 Then
130 .FindFirst "[quote_id]=" & Me.quote_id
140 If .NoMatch Then
150 MsgBox "Booking Member Quote not Found: " & Form_frmGrpClSel.quote_id
170 Form_frmGrpMbrs.Bookmark = .Bookmark
190 End If
200 End If
210 End With
Can anyone help please?