MS Access / VBScript Question

[keeshaun]

I am trying to write a code in MS Access 2000 using VBScript that will allow me to check a checkbox on a form automatically whenever a certain value of a drop down field is selected on a higher level form. Any ideas, suggestions or tips that would be helpful???

[vb_dba]

Say we have Form1 and Form2. Form1 contains your check box(Check1) and Form2 contains the combobox(cbo). In the After Update event of the combobox, you would need:

If cbo.Value > 5 Then
   [Forms]![Form1]!Check1.Value = 1
Else
   [Forms]![Form1]!Check1.Value = 0
End If

This should get you pointed in the right direction.

[Ephesians]

If that doesn't work, set the value of the checkboxes with True and False as the numeric equivalent is 0 (false) and -1 (True) and this sometimes is confusing.