D
D. Green
Greetings, I am working with Access 2003. My subform name is Stock Number
Subform: Form, and contains fields such as Stock ID, Qty Order, Qty Issue,
and Qty Back Order. I have created a check box on the subform with the
control source that is =[qty back order]>0=True and the check box name is
Open Back Order. What I am seeking to do is to not have the control source
of the check box as the current source listed but to be control by the sum of
the available data in other table’s fields. I have a table name Back Order
Table Log: Table, that as field such as Stock ID, and Back Order Issue, and
another table which is the source of the subform and name Stock Number: Table
and contains field name Stock ID, Qty Order, and Qty Issue. How would I
implement a procedure to have the check box identified True or False by
calculating the data from Back Order Table Log and Stock Number tables?
Thank you very much for your assistance.
Subform: Form, and contains fields such as Stock ID, Qty Order, Qty Issue,
and Qty Back Order. I have created a check box on the subform with the
control source that is =[qty back order]>0=True and the check box name is
Open Back Order. What I am seeking to do is to not have the control source
of the check box as the current source listed but to be control by the sum of
the available data in other table’s fields. I have a table name Back Order
Table Log: Table, that as field such as Stock ID, and Back Order Issue, and
another table which is the source of the subform and name Stock Number: Table
and contains field name Stock ID, Qty Order, and Qty Issue. How would I
implement a procedure to have the check box identified True or False by
calculating the data from Back Order Table Log and Stock Number tables?
Thank you very much for your assistance.