create multiple records

B

BK

I am creating an inventory database where I need to create the inventory
first, and then associate it to an account. I am having trouble figuring a
way to create the inventory, because there could be more 100 created at a
time (this would be time consuming if done one at a time.) What I would like
to do is have an unbounded form with a drop-down list with the three types of
items, and an amount field where you can specify how many of the selected
items to create. Finally, I would like a command button which would append an
inventory table with the specified number of items. I am have my problems
with the command button. I do not know VB, and I think this can only be done
with VB. I hope someone can help.

Thanks
BK
 
Top