Using an unbound textbox next to each record in form, with all records showing?

J

justme0010

I am working with an inventory system, and would like to have a for
that shows all products and their current inventory levels, and next t
each of them have a textbox for entering in new inventory levels. I
this possible somehow? I can't seem to so it with continuous forms. I
it possible to have run-time created textboxes? Any ideas would b
greatly appreciated
 
A

Al Campagna

justme,
I'm not sure how the setup you described would be used in an inventory
system. You'll have to give us more information as to what data you have,
and how you plan to calculate inventory totals.

But... think of an inventory as a checkbook... money in-money out.
ex. table...
PartNo Desc Credit Debit
1234 Widget 100
9876 Bolt 50
1234 Widget 25
1234 Widget 10
9876 Bolt 10

In a Totals query, GroupBy PartNo and Desc, and SumOfCredit - SumOfDebit
would give you the OnHand for every item.
PartNo Desc OnHand
1234 Widget 65
9876 Bolt 40

--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."
 
J

justme0010

My system would record the changes in inventory level by calculating th
difference between the new inventory level and the system level. I woul
be recording them as 'pos. inv. adjustment' or 'neg. inv. adjustment
depending on the new level. I would have VBA code to perform that logi
and record that information into my transactions table. I would jus
like to know how I can have the user enter in a value next to
description and system level of all the items in the system
 
Top