Is there a VBA method for copying a single record in form view?

  • Thread starter Thread starter Mac Hardy
  • Start date Start date
Access doesn't really have a concept of "last record of a table". Tables are
unsorted sacks of data: Access will stick records wherever it wants.

The only way to ensure order is to use a query with an appropriate ORDER BY
clause.

Assuming you've got an appropriate ORDER BY clause, you can use the TOP 1
predicate.
 
Back
Top