Increasing a number by the value of the last record

[westfallbp]

Kind of embarrassed asking this question: I am doing a database for a friend. I have a field on a form called Item# where he enters a number for example if he enters 2 it shows 2.000 which is in the correct format. What I am trying to do on the continuous form is place a command button that he can select and it will copy and paste his Item. for example choclate bars, his distributor which are fields also and add new record, fill in the item, distributor, and add .001 to the previous record. any help would be greatly appreciated. Be nice if a macro but vba code I can do also. Thanks

[Welshgasman]

About to go to a Teams meetings.
Best not to have characters like # in fieldnames. Nothing wrong in having in a caption for that field.
Most people here do not use macroes, so it will be VBA.

[westfallbp]

Wow! that really helped me out a lot..Will change Lot# to Lot Number Still have the same problem

[Gicu]

You can do it with an append query (using the current record of the continuous form) and increment the value of the item # in there Item_No:[Item#]+0.001 or you can save the values of the desired fields in variables, go to a new record and start populating the empty fields with the saved values.
Give it a try and come back if you get stuck.
Cheers,

[moke123]

Wow! that really helped me out a lot..Will change Lot# to Lot Number Still have the same problem

To help you out more, I wouldn't use Lot Number either. You should not have spaces or special characters in field or object names. Try LotNumber or LotNbr.
If you do choose to use spaces be sure to enclose the entry in brackets.

[Welshgasman]

Kind of embarrassed asking this question: I am doing a database for a friend. I have a field on a form called Item# where he enters a number for example if he enters 2 it shows 2.000 which is in the correct format. What I am trying to do on the continuous form is place a command button that he can select and it will copy and paste his Item. for example choclate bars, his distributor which are fields also and add new record, fill in the item, distributor, and add .001 to the previous record. any help would be greatly appreciated. Be nice if a macro but vba code I can do also. Thanks

I used to have a checkbox that indicated whether I wanted to repeat certain fields on a new record. Worked very well as I entered over 23K records reasonably easy.

I had similar code for each control I wanted with the same values.

Private Sub Rank_ID_AfterUpdate()
    If Me.chkCopy Then
        Me![Rank_ID].DefaultValue = """" & Me![Rank_ID].Value & """"
    Else
        Me![Rank_ID].DefaultValue = 0
    End If


End Sub

I dare say it could be turned into a sub and be called from any control.
However this was my first Access DB, so learning as I went.

[westfallbp]

Thanks for the input, I reas some other post and just used VBA and reset the default value + 1 and it worked