set value in combo box based off check box

[scowens36]

I am looking for either VB code or Macro setting that will set the value in a combo box if a certain check box is selected on my form. Reason for this is I have data entry people forgetting to set the overall status of a packet when we receive it. So I am wanting the overall status to be set to "Received" in my combo box (There are multiple status that a package can have in this combo box) when they check the Received checkbox. Any help would be appreciated... Thanks..

[alansidman]

In the afterupdate event for the check box try:

If me.checkbox.value = -1 Then
me.combobox.value = "Received"
End if

change the names of the controls checkbox and combobox to your control names.

[scowens36]

alansidman, Thanks for the help. It is working great. No more data correcting for this issue. This will make a big difference.