Data entered stays the same until command button is clicked

[dizzl3e]

Hello,

So I have a form that has the textboxes username and Shipment number. Data
is entered in the textboxes via barcode scanner. Everything is working
great. when I scan a username barcode it enters the data to the username
field and then scan the shipment number and enters the data on the shipment
number field. Once both are scanned the macro then adds the record to the
db and restarts the process again.

Now I need help in trying to make the program a run little more efficient I
just want to scan the username once and continue scanning the shipment
number. From this process the username should continue to remain the same
for every record added until I click on the "Finish" button. I hope what
I'm trying to explain makes sense.

Any help is greatly appreciated. Thanks in advance.

 

[Jeff Boyce]

So you want to enter multiple "shipment numbers" per "username"?

It sounds like your form is set up to require both values ... and this might
imply that your table is set up to require both.

If one user can have multiple shipments, have you considered using more than
one table (one-to-many, user-to-shipments)?

You could use a mainform/subform to do something very much like what you've
described, and you would load the username once, then all the shipments for
that user, before picking a new user.

Or did I misunderstand...?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or psuedocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[dizzl3e]

Jeff, thanks for your response. You pretty much hit the nail on the head.
Originally I wanted to do multiple tables, (user, shipments) but due to the
simplicity of the request I figured one table would suffice. But with the
added request it seems I will have to do multiple tables to accomplish this
task. I will try what you suggested. Thanks again.