Check box validation

[mitch_moseley]

At the moment I am doing a database as part of my A level. On my form I have two tick boxes; Invoice dispatched? and Paid? I need to make it so the 'Invoice dispatched' box has to be ticked before the 'Paid' box can be ticked, so the paid box can't be ticked unless the invoice box is ticked. Is there any validation rule that makes this happen?

 

[BlueIshDan]

chkInvoiceDispatched onClick Event:

chkPaid.Enabled = CBool(chkInvoiceDispatched.Value)

Try that out.

 

[Christos99]

I would by default make the Paid checkbox 'enabled = false'
then in the AfterUpdate event for dispatched (if checked), set the Paid checkbox 'enabled = true'.
You may need to do it in the Current event for the form too, in case returning to a record where dispatched is checked.

 

[gemma-the-husky]

we don't normally help with homework, but this is how.

you need code, rather than validation.

you need code in the current event, and in the dispatchedafterupdate event. you need it in both so that it works as you navigate through records, and after you change the current record. This is a general thing with validation stuff like this. You generally need to add stuff to the current event.

note that it is still not properly debugged, as a user COULD tick dispatch, then tick paid, then untick dispatch.

but anyway

 if chkdispatched then
     paid.enabled =  true
 else
     paid.enabled =  false
 end if

this can be stated more concisely, but maybe slightly harder to understand, as

 paid.enabled = chkdispatched

 

[Minty]

You should have the Paid check box disabled /hidden until the invoice check box is updated to Yes.

Attach an after update event to the invoice check box something like

 If me.chkInvoicePaid = 1 Then
me.chkPaid.enabled = True
End if

Substitute your form field names where appropriate.
You should also code it to reverse this if the box is unticked.