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

  • Thread starter Thread starter Mac Hardy
  • Start date Start date
M

Mac Hardy

I want to copy the last record of a table (while in form view). How?
 
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.
 
You must log in or register to reply here.

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

Sync/Link 2 forms 2
Using Check Boxes to select items in an Access subform. 0
Use VBA to set form control to value in a non-master/child subform? 0
Open a form with TABS from another form 1
Add new record through Form view 4
The newly created record is now shown in the form 3
Speeding up "1 of X" 0
Convert a form to a split form? 0

Back
Top