Working with Y/N checkboxes

  • Thread starter Thread starter Kema
  • Start date Start date
K

Kema

On an Orders Database, I track which lines are complete
in ORDERDETAILS with a Y/N checkbox [LineComplete].

I also track which ORDERS are complete with a Y/N
checkbox [OrderComplete]on the Orders Form.

Obviously an order can not be complete without all lines
being completed.

I want to allow the [OrderComplete] check box in Orders
to be checked ONLY when ALL [LineComplete] checkboxes in
OrderDetails have been checked for that order.

Thaks for the help.
 
Try this:

Me.[OrderComplete] = Me.[LineComplete]

If [ORDERDETAILS ] is a subform of form [ORDERS ] you should use this code
instead:

Me.[OrderComplete] = Me.Forms.[ORDERDETAILS ]![LineComplete]

Where Me.[OrderComplete] is the checkbox (Yes/No, Boolean) you want to
update depending on
checkbox [LineComplete].


// Niklas
 
Back
Top