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

D

Douglas J. Steele

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split form 0
Adding data to MS Access from csv file 0
Crating User Form to Add Names 1
Copy previous record into form field 0
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
Format column widths from one table to a separate table on same page 1
Filtered view of Visio Chart 0
Create form with checkbox les that expand and collapse sections of the form? 0

Top