MS Access / VBScript Question

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???

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:

VB Code:

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.

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.