Subform with static records (1 Viewer)

[Sym]

Im trying to make an Inventory count form with the basic info like employee name and date in the parent form then all the products i have in inventory listed in the subform along with a count field to input the count numbers.

I can get it to work but you have to enter the item number and the count for each record. To lessen the chances of input error i want all the item numbers to be static or already loaded in the subform when it opens then all i have to do is enter the count numbers. is that possible? if so how would i do that?

Thanks

 

[pbaldy]

Don't know your structure, but you can probably run an append query to populate your "count" table from your "products" table.