Andy Lacey
andy at minstersystems.co.uk
Thu Jan 18 04:00:39 CST 2007
John It'd be something like: With Me.RecordSetClone .FindFirst "YourPrimaryKeyField=" & Me.txtKey If Not .Nomatch Then Me.BookMark=.BookMark End If End With Assumes a field like txtKet holds the record number sought -- Andy Lacey http://www.minstersystems.co.uk --------- Original Message -------- From: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Subject: [AccessD] VBA syntax for selecting a record Date: 18/01/07 09:38 What would be the correct VBA syntax for selecting a record on a continues form using the primary key? TIA John B. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ________________________________________________ Message sent using UebiMiau 2.7.2