Use Datasheet Form to add records to table

[gemadan96]

I have a table of items in inventory. I want a form that shows a blank datasheet to add new item to the iventory list. The user will be using a barcode scanner to enter the item's barcode only then moving to the next new record. Other information for the item is determined by default values based on each item. There are for type of items: Item A, Item B, Item C, and Item D.

When the user clicks the button for "Add Item A" to inventory I want a form to open with a blank data sheet to enter the barcodes. Then they need to scan the barcodes. When they're done they'll see a list of barcodes on the screen and be able to close the form. They're will be buttons for each item for accomplishing the same for them.



Any suggestions?

[pbaldy]

Sounds pretty simple; where exactly are you stuck? You'd use the after update event of the textbox they're scanning into to move to a new record.