S
Stephen
I have an Orders Database.
On my PRODUCTS Table along with Item, DefaultCost,
DefaultSell, I have a field called [Actual/Estimated].
It is a checkbox on a form to indicate if the weight of
that particular item has an actual or estimated weight.
On my ORDERS Form I have an
OrderDetailsForKitchenPrepSubform.
Products for my Order Details are selected from the
Products Table. All fields are populated automatically
based on the Product Selected.
In the OrderDetails form I have a checkbox to indicate if
a line has been completed [LineComplete].
Here's what I need help with:
I want the the Weight to appear as White on a Blue
backgroound if the weight is estimated. The user must
also be prevented from clicking the LineComplete box.
This allows a user to know this item has an estimated
weight and must be updated.
AFter the user updates the weight of this item I would
like the Weight to appear as Black on a White Background.
At this point the user can click the LineComplete box.
Basically, I want to force the user to update a line 1
Time that has an estimated weight. Once that Line has
been updated there would be no need to update it again.
Thank you for the assistance.
Stephen
On my PRODUCTS Table along with Item, DefaultCost,
DefaultSell, I have a field called [Actual/Estimated].
It is a checkbox on a form to indicate if the weight of
that particular item has an actual or estimated weight.
On my ORDERS Form I have an
OrderDetailsForKitchenPrepSubform.
Products for my Order Details are selected from the
Products Table. All fields are populated automatically
based on the Product Selected.
In the OrderDetails form I have a checkbox to indicate if
a line has been completed [LineComplete].
Here's what I need help with:
I want the the Weight to appear as White on a Blue
backgroound if the weight is estimated. The user must
also be prevented from clicking the LineComplete box.
This allows a user to know this item has an estimated
weight and must be updated.
AFter the user updates the weight of this item I would
like the Weight to appear as Black on a White Background.
At this point the user can click the LineComplete box.
Basically, I want to force the user to update a line 1
Time that has an estimated weight. Once that Line has
been updated there would be no need to update it again.
Thank you for the assistance.
Stephen