Update Form

  • Thread starter Thread starter esi
  • Start date Start date
E

esi

I have created a form to do cycle countng of items in our stock room. The
form is based on a query which pulls the sku#, item name from the item
master table, system qty from a system table, and qty in process from
another system table. I need to include a text box for the counter to enter
the cycle count from the shelf. Should this be an unbound field or a blank
field in my query? Ultimately, when all the designated items are counted, I
want to take all the values from the form and upload them into an item
history table which will track our counts for all items. Wondering what
exactly I need to do.
 
Since you already have 2 sets of numbers, you should probably just create
another table to keep track of the cycle counts and have 3 sets of numbers.
I don't know if you need the other pieces of information while entering
these counts so just base your form on this new table.

Kelvin
 
Back
Top