copy last record

[Erik]

I have a table call tbl_houses that i am storing data. I have a form called
frm_add_house and on that form i have 3 txt boxes (housename,setnumber,and
version) I would like to copy the last record when I click on the add new
record command button. Any help would be great. Thanks.

 

[Roger Carlson]

In the form design view, there is a command button wizard that will do that.
Click the Command Button tool on the toolbox and click in the form. A
wizard will come up. Select Record Operations then Duplicate Record and
follow the prompts. If you're in the last record, that's all you need. If
you're not in the last record, use the code you can find in the wizard under
RecordNavigation > Go to Last Record.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Erik]

The form is in data entry and when i create the command button it siads that
the copy feature is not available. I would like to code it, because i only
want some of the boxes filled in, not all. Thanks