Subform

[Jonny45wakey]

Hi I have a form called "frmTransactMovements" which has a checkbox called "Approved" on it.

On the above form is a Subform called "frmDocMovements" and it has a combobox called "state_Id"

Is there a way that when a certain value in "state_id" combobox is selected, after update it ticks the "Approved" check box on the form?

Thanks

Jonny

 

[Gasman]

Perhaps place in the AfterUpdate of the combobox, something along the lines of

If combobox="whatever" then
    Me.Parent.checkbox = True
End If

Amend the names to suit.

HTH