How to locate a multi-criteria record?

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top