[AccessD] VBA syntax for selecting a record

A.D.TEJPAL adtp at airtelbroadband.in
Fri Jan 19 00:09:50 CST 2007


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.


More information about the AccessD mailing list