Inventory Form Help!!!

[Avid Reader]

Hi all, I'm trying to modify the Inventory Database that I downloaded from
the Access download site. Here's what I have so far and still what I'm
trying to accomplish.

1.) I've been able to change the form and add the table values that relate
to my data.
2.) I've also changed the subform so that it displays data from the unbound
form as I type or select data

Problem:

Now where I'm running into problems and I'll try to explain this as best as
possible, is that my unbound text box is a lookup or select to a product
field and as long as I select the product from the list, the other
information is selected in the subform. What I would like to do is to be
able use a scanner to scan in the product number's barcode and have it
select the correct prod in both the main form and the subform. What I'm
currently getting is that when I scan the item just the item number is
displayed and not the selected said item. I'm very new to using forms and
have very little experience in VBA.

Ideally what I would like this database to accomplish is that I'm able to
load it onto a laptop and hook up a scanner to the laptop and scan the items
barcode, put in a quantity, summarize the totals for all inventory items and
upload the data into our ERP system.

I know that I've rambled a bit and for that I apologize just hoping that
someone can help me through this foggy situation.


BTW I'm using Access 2003 but converting it to Access 2000 for the persons
that will be taking inventory.

 

[[MVP] S.Clark]

Scanning the number is the same as typing the number. If you don't do
anything else, then nothing else will happen.

Assuming that you're using the Link Child/Master Fields to perform the link,
just entering the number is only half the action. So, after the value gets
in, you need a trigger that says, "I'm done.... requery"

There are options available, like OnExit, OnChange, AfterUpdate, etc.
You'll have to find the one that works best for what you're working around.