Product entry form- duplicate last record in table/copy/paste in new record

[progenesis]

This is what i have. i have been working on product database and i am new at access. i have made 1 database with access and am decent with excel formulas and wanted venture over to the world of access. i have a simple form with a combo box, for the person i am giving the product too, a text box, for the date i gave it, and another text box for the serial number of the product. when entering in the data it will be 20-30 serial numbers at a time for the same date and same person. My idea was to selectallrecords, copy, getnewrecord, paste then null the serialtxt. This works for a button(thanx button wizard). My problem with it is when inputting the serial numbers i am using a barcode scanner. i would have to click a button everytime to update the Table. How do i do the same without using a button? I have tried the onEnter function on the serialtxt and it would not let me enter in the serials.



I have searched the forum/google and could not find anything that i seen as relevant and have been stuck on this for a couple days(not constant working on it, i do this in spare time while working).

[Missinglinq]

Why not simply use the AfterUpdate events of the Controls holding your person and date to set the DefaultValues for the Fields. From that time forward, until you either manually change the data or close your form, the data will be entered automatically for these Fields in each New Record. The code would go like this:

Private Sub YourControlName_AfterUpdate()
   Me.YourControlName.DefaultValue = """" & Me.YourControlName.Value & """"
End Sub

The above syntax is valid for Text, Number and Date Datatypes.

You’ll need to do this for each Control that you want to 'carry forward.'

Linq ;0)>

[progenesis]

worked perfectly. Thank you!

[Missinglinq]

Glad we could help!

Linq ;0)>