opopanax666
Registered User.
- Local time
- Today, 00:57
- Joined
- Nov 2, 2006
- Messages
- 44
Hi everyone,
Situation: I have a main form (see attachment) based on "tblOrders" with a continuous subform showing our products and their stock, and an unbound control to input the amount ordered. This subform is based on a series of queries that calculate the stock of every product, dependant on what has been produced, what has been delivered, and what has been reserved by other shops. In the header of the subform are 10 grouped option buttons, which change the recordsource of the subform through VBA, so users can "cycle" through our different productgroups (all this works)...
Problem: I know that an unbound control in a continuous (sub)form is difficult to manage (seeing that it is, in fact, only 1 control but repeated throughout the form). But this is the way I would like to present the data (instead of using cascading comboboxes), so VBA should be able to give me a solution
.
The rows where the user has inserted an amount should be transferred to "tblOrders - details" (which is linked to "tblOrders" through the "Order_ID") when they press the "Klaar!" button, so that I get in "tblOrders - details": ID (autonumber) Order_ID (from main form) Product_ID (from subform) Amount (from subform).
This is going to be used in a Citrix client/server setup, with possibly 7 users, so using a temporary table would make things too complicated (I think). Recordsets would be the way to go, I guess
Does anyone have a clue as to how to implement this?
Thank you for any feedback!
Situation: I have a main form (see attachment) based on "tblOrders" with a continuous subform showing our products and their stock, and an unbound control to input the amount ordered. This subform is based on a series of queries that calculate the stock of every product, dependant on what has been produced, what has been delivered, and what has been reserved by other shops. In the header of the subform are 10 grouped option buttons, which change the recordsource of the subform through VBA, so users can "cycle" through our different productgroups (all this works)...
Problem: I know that an unbound control in a continuous (sub)form is difficult to manage (seeing that it is, in fact, only 1 control but repeated throughout the form). But this is the way I would like to present the data (instead of using cascading comboboxes), so VBA should be able to give me a solution
.The rows where the user has inserted an amount should be transferred to "tblOrders - details" (which is linked to "tblOrders" through the "Order_ID") when they press the "Klaar!" button, so that I get in "tblOrders - details": ID (autonumber) Order_ID (from main form) Product_ID (from subform) Amount (from subform).
This is going to be used in a Citrix client/server setup, with possibly 7 users, so using a temporary table would make things too complicated (I think). Recordsets would be the way to go, I guess
Does anyone have a clue as to how to implement this?
Thank you for any feedback!
Attachments
Last edited:
