checkbox dependencies

[jle0003]

I have a form that has a subform. There is a combobox on the Main form and a combobox plus a checkbox on the subform.

I would like the checkbox automatically checked or unchecked based on the values selected in both comboboxes.

For example, if I select "red" from the main form combobox AND "apple" from the subform combobox, I want the checkbox to automatically check.
Or if I select "red" from the main form combobox and I select "banana" from the subform combobox then I want the checkbox to automatically uncheck.


I also need these to dynamically refresh so that the user does not have to make changes to both comboboxes for the checkbox to refresh.\

I have tried everything I know about dependent comboboxes and requerying and nothing is working. Any ideas? Some sample code would be much appreciated!

[June7]

Code would have to be in the AfterUpdate event of both comboboxes.

Example of code for the color combo:
If Me.colorbox = "red" And Me.subformcontainername.Form.comboname = "apple" Then Me.subformcontainername.Form.checkname = True
ElseIf ...

See what you have got yourself into? Why do you need the checkbox?