Scan a UPC on a txtfield on mainform & add to subform Please Help!

Access Discussion in 'Microsoft Office' started by yeasir01, Jul 15, 2017.

  1. yeasir01

    yeasir01

    Joined:
    Nov 21, 2014
    Likes Received:
    0
    I'm creating a simple inventory stocktake database for tracking inventory bought from certain vendors. I dont need to subtract inventory sold or anything like that just inventory intake. Hope that makes since.

    My objective it to have a form that I open, set the date vendor & invoice number then place the focus on the scan txt box & start scanning using a wedge type scanner (Basicly inputs the barcode data & then hits the enter button). I prefer this method because I can input the information much quicker than finding the item in a combobox and setting the quantity.

    I've created all the necessary tables & set the relationships to accomplish this. What I can't figure out is how to have the scan txtbox linked from the mainform to the sub or make the box lookup UPCs that are related to the product & produce 1 item per scan to add to the purchase order detail subform. Or change the qty if the item exist on the list. I have no VBA experience, iv tried using macros with no success. I would really appreciate someones help on this

    I attached a copy of the DB im working on for review.
     

    Attached Files:

    yeasir01, Jul 15, 2017
    #1
    1. Advertisements

  2. yeasir01

    yeasir01

    Joined:
    Nov 21, 2014
    Likes Received:
    0
    Any help guys?
     
    yeasir01, Jul 18, 2017
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.