Access 2010 Checkbox & Validation Rules

[mrmims]

Hello,

I am creating a "Web Compatible" database in Access 2010 for tracking training of my employees.



In table "EmployeeTrack" I have checkbox "InTraining", that when checked makes visible a combobox "TrainerCB". When the "InTraining" checkbox is checked I want the "TrainerCB" to be a required field, but on't with "InTraining" is checked.

How do I do this with validation rules in a web compatible table?

Thank you

[ranman256]

Usually the validation property only uses simple math checks, I have never tried referencing externeal forms. You may have to write some code in the 'after update' event to check validation.
I usu have a check on the 'Save' button that validates all the fields 1st...

Private Function IsValidForm() As Boolean
Dim vMsg
Select Case True
   Case IsNull(txtFile)
      vMsg = "File is missing"
   Case IsNull(txtTblData)
      vMsg = "Table name is missing"
End Select
If vMsg <> "" Then MsgBox vMsg, vbCritical, "Required Field"
IsValidForm = vMsg = ""
End Function