how to copy last entry data for new entry

[alexandervj]

I've got an inventory database for our parts, and our parts usually come in lots. So could be 20 - 30 parts with roughly the same information that needs to be put in the database at a time with a few slight variations. Is there a way I can copy from the last entry certain fields or something so the fields that will have the same information will get copied from the last entry if a check box is checked or something like that? Thanks

Actually this is what I'm looking for but functions with a checkbox with an if statement. ie if checkbox then copy values from last entry

http://allenbrowne.com/ser-24.html

[June7]

Why bother with the checkbox? Why does user need to choose? Just set the DefaultValue property. It's not engraved in stone, user can still change to whatever they want and it's one less click.

Allen's code may be more elaborate than you need.

In the BeforeUpdate event procedure for control:

Me.controlname.DefaultValue = Me.controlname

[alexandervj]

I would rather have it update the data after a checkbox has been clicked or at least a button is pressed. Theres about 6 fields that need to be autofilled with data from the previous entry and it can get a little confusing for users exactly what data to enter if all the data is already filled all the time. I just want this to happen if it the part was manufactured in the same lot

[June7]

The DefaultValue property must be set while on the record where the values were entered.

Alternatively, use hidden textboxes on form (or global declared variables) to populate with the data and reference those entities when checkbox clicked or button clicked to simply populate fields of new record.

[alexandervj]

thanks very much for your help. I'm pretty much a complete noob, how would i implement that code? Thanks again

[June7]

Which do you want, hidden boxes or global variables? I avoid global variables because during debugging they will be wiped out when code is interrupted.

In the BeforeUpdate event of form, populate the hidden textboxes with values from the data entry controls:

Me.textboxname1 = Me.controlname1
...

Then in the button Click event, populate the fields of the current record, but maybe only if the field is null:

If IsNull(Me.controlname1) Then Me.controlname1 = Me.textboxname1
...

[alexandervj]

I don't seem to have a BeforeInsert or BeforeUpdate property in the events of my form :/
Is this because I'm using a web database? Maybe I'm missing something....

[June7]

Could be, I am not very familiar with web databases. You do have Data Macros but I am not sure if can do what you want with them.