[AccessD] VBA syntax for selecting a record

Thanks Andy, that worked. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey

Well I don't reckon it'd be much different. Try

With Forms("Yourformname").Form
  .RecordSetClone.FindFirst "YourPrimaryKeyField=" & Me.txtKey
  If Not .RecordSetClone.Nomatch Then
    .BookMark=.RecordSetClone.BookMark
  End If
End With