Rixx
Registered User.
- Local time
- Today, 13:52
- Joined
- Mar 3, 2005
- Messages
- 25
Hi,
I have two queries. One query calculates the current stock level. There is an expression :
Items in Stock: Sum(Items.ItemStock-Newstockpart1.Quantity)
(there is one query and one table as the basis for this query/calculation).
I have another query where only the Items table forms its basis. The reason for this query is to "prompt" for the user to type in the productID. Upon a successful entry, the relevant record is displayed from the items table and edits can be made.
I have a form that links to the second query.
In this form, I have a field that is called "Holding stock". I want the current stock value to be displayed here (which is what the 1st query calculates). However, I cannot get this value to show up in my second query.
I have combined these two queries in design view, but when I use the form, I cannot edit any of the information! The whole idea is so that the user can see what the current stock level is on the same form, enter a quantity for a delivery, the form then adds these two numbers and the user enters this calculated number in a field which is bound to the Itemsinstock field in the items table.
Any assistance will be appreciated
Thanks in advance.
I have two queries. One query calculates the current stock level. There is an expression :
Items in Stock: Sum(Items.ItemStock-Newstockpart1.Quantity)
(there is one query and one table as the basis for this query/calculation).
I have another query where only the Items table forms its basis. The reason for this query is to "prompt" for the user to type in the productID. Upon a successful entry, the relevant record is displayed from the items table and edits can be made.
I have a form that links to the second query.
In this form, I have a field that is called "Holding stock". I want the current stock value to be displayed here (which is what the 1st query calculates). However, I cannot get this value to show up in my second query.
I have combined these two queries in design view, but when I use the form, I cannot edit any of the information! The whole idea is so that the user can see what the current stock level is on the same form, enter a quantity for a delivery, the form then adds these two numbers and the user enters this calculated number in a field which is bound to the Itemsinstock field in the items table.
Any assistance will be appreciated
Thanks in advance.
Last edited:
