J
Jon Mckay
Hi, forgive me if I'm being dense here! I have a database in which
information on items of stock are held for a store room in the IT dept of
Barclays Capital in the UK. The database includes various fields such as
reference numbers, person added stock, notes,, and so on. Everything works
fine with my "add new stock" form and my "add descriptions" forms. However I
stumble when I try to create a form for removing stock.
My design involves having a yes/no field to say if the item has been
deployed or not and another field for engineers to select their name. I plan
to have this updated by a separate form that engineers can update to take
stock out. All items have an ID based on the key field (which is autonumber)
... Now the problem.
I cant / dont know how to input a number into a form and have the database
lookup the field > bringing up the record for my users to amend by using the
other fields in their remove stock form.
Can anybody help me here???
Thankyou a lot if you can.
Jon McKay
information on items of stock are held for a store room in the IT dept of
Barclays Capital in the UK. The database includes various fields such as
reference numbers, person added stock, notes,, and so on. Everything works
fine with my "add new stock" form and my "add descriptions" forms. However I
stumble when I try to create a form for removing stock.
My design involves having a yes/no field to say if the item has been
deployed or not and another field for engineers to select their name. I plan
to have this updated by a separate form that engineers can update to take
stock out. All items have an ID based on the key field (which is autonumber)
... Now the problem.
I cant / dont know how to input a number into a form and have the database
lookup the field > bringing up the record for my users to amend by using the
other fields in their remove stock form.
Can anybody help me here???
Thankyou a lot if you can.
Jon McKay