[AccessD] VBA syntax for selecting a record

John,

    Simple statement as given below, should be able to serve the purpose. MyID is the variable carrying desired value of primary key named ID (number type).

    Me.Recordset.FindFirst "ID = " & MyID

Best wishes,
A.D.Tejpal
---------------

  ----- Original Message ----- 
  From: John Bartow 
  To: 'Access Developers discussion and problem solving' 
  Sent: Thursday, January 18, 2007 15:07
  Subject: [AccessD] VBA syntax for selecting a record


  What would be the correct VBA syntax for selecting a record on a continues form using the primary key?
   
  TIA
  John B.