Subform Combobox

[Jonny45wakey]

Wondering if anyone has the wisdom to solve this for me please?

I have a form called "frmTransactMovement" which has a textbox called "status", on the form is a subform which contains a Combobox called

"id_State" with a dropdown selection of "Approved"

What i would like to happen is when the subform combobox is changed to "Approved" the textbox called "Status" in the main form has its field value changed to "Yes" or "Approved"

Cant seem to get this to work, any pointers / help appreciated.

Thanks

Jonny

 

[arnelgp]

add code to the combo_AfterUpdate event:

private sub combo_afterupdate()
me.parent!txtStatus = iif(me!combo = "Approved", "Yes", "No")
end sub