Moving to Specific Record

[Guest]

I wish to search a form that contains certain data in a subform. I can search
for the correct record identifier (not the forms recordset ID) and tried to
perform a "seek" using the command

me.recordset.seek "=", ResultantEventID

but an error is returned stating the method is not available for this
object. The recordset is a query based on an ODBC data connection.

Is there a way to move to the form's record where the recordset's field name
"EventID" is equal to the resultant value? The form's recordset is not
ordered by EventID.

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ComboChoosesRecord.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L