M
mekmike1
Any suggestions on how to locate a multi-criteria record, which will be
unique, and then make the form show that record? I am using ADO and have had
no luck using:
rsMainData.Seek Array(Me![Search_typ_box].Value, Me![Search_srl_box].Value),
adSeekFirstEQ
If rsMainData.EOF = False
Me.Bookmark = rsMainData.Bookmark
End If
I get a run-time error '3159' "Not a valid bookmark"
Is there a simple way in ADO to set the forms bookmark to a recordset's
bookmark?
Any suggestions would help.
unique, and then make the form show that record? I am using ADO and have had
no luck using:
rsMainData.Seek Array(Me![Search_typ_box].Value, Me![Search_srl_box].Value),
adSeekFirstEQ
If rsMainData.EOF = False
Me.Bookmark = rsMainData.Bookmark
End If
I get a run-time error '3159' "Not a valid bookmark"
Is there a simple way in ADO to set the forms bookmark to a recordset's
bookmark?
Any suggestions would help.