Forms: Copying text value to same field in next record?

[Horsefeathers]

Greetings... this is my first post here, so apologies in advance for the wordy explanation of my situation.

Here it is: I'm designing a database for tracking the ingress/egress of inventory by serial number. At this point I'm stumped on the "receive inventory" form. What I'm trying to do is provide a form with four text boxes -- Date, Name, PartNumber and SerialNumber. Date function is trivial, figured that one out. SerialNumber is to be scanned in, so no problems there... but Name and PartNumber are a problem. I need for the text form to automagically repeat (DefaultValue?) the most recent entry used in that form -- to avoid unnecessary repetition, so the receiver can simply type/select a name and part number and then rapid scan any boxes corresponding to that part. Then when a different part needs to be "received," the new value can be either typed in or selected, rapid scanning of SNs following accordingly. I know this can be done, but for the life of me, I can't find what I need to get it done. I hope this makes sense to someone... TIA

[ADezii]

Greetings... this is my first post here, so apologies in advance for the wordy explanation of my situation.

Here it is: I'm designing a database for tracking the ingress/egress of inventory by serial number. At this point I'm stumped on the "receive inventory" form. What I'm trying to do is provide a form with four text boxes -- Date, Name, PartNumber and SerialNumber. Date function is trivial, figured that one out. SerialNumber is to be scanned in, so no problems there... but Name and PartNumber are a problem. I need for the text form to automagically repeat (DefaultValue?) the most recent entry used in that form -- to avoid unnecessary repetition, so the receiver can simply type/select a name and part number and then rapid scan any boxes corresponding to that part. Then when a different part needs to be "received," the new value can be either typed in or selected, rapid scanning of SNs following accordingly. I know this can be done, but for the life of me, I can't find what I need to get it done. I hope this makes sense to someone... TIA

You hit the nail on the head- programmatically change the Default Values for the Fields involved, and these values will automatically show when New Record(s) are added.

[Horsefeathers]

Thanks for the reply. Sorry if I was less than clear about what I'm trying to do. I understand how to apply a "static" default value as you descibed, but this is a little different. What I am specifically trying to do here is to allow the end user to enter a value in a text box, and then make that entered value appear in that field for all subsequent record entries -- until the user changes it. This form will be used for receiving multiple units of single stock items -- where the employee will select or enter a part number one time (until moving on to the next pn), then simply scan each barcode corresponding to that part number. The reason for doing this is to avoid wasting time on repetitive part number entries. I'm guessing there's a handy VBA trick for this, but I'm not very conversant in VBA... yet. ;)

[kepston]

In the AfterUpdate event of your part number (here as PartNo) field:

Me.PartNo.DefaultValue = Me.PartNo

[Horsefeathers]

In the AfterUpdate event of your part number (here as PartNo) field:

Me.PartNo.DefaultValue = Me.PartNo

Thanks for the reply.

I copied the code into the AfterUpdate property (and checked that the name of the control was set to 'PartNo"), but in testing it I got an error saying that "Access can't find the macro 'Me'." Seems I am missing something...

[Horsefeathers]

Nevermind, I figured it out. Thanks again for the code help.

For those who run into a similar problem, I did the following:

In the "After Update" event, select [Event Procedure].
Click on the [...] ellipsis on the right.
type (or paste) [Me.PartNo.DefaultValue = Me.PartNo] (w/o the brackets) or whatever code applies to your situation.
Save and close the VBA page.

Great forum! Many thanks to all who responded... I hope I can someday return the favor. :)