I Need VBA Assistance to point a variable to a record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good afternoon,

I need to know a VBA command to set an integer variable in an Access module
to be pointed to a certain record number in a table so that the variable
takes on whatever value is in the record. Any suggestions? Thanks.
 
if you need to get a record say #25, then you can get top 25 from your
table:

select top 25 * from MyTable

open this query in a recordset, then move to the last record and get
necessary field value
 
Back
Top