Open popup if user enters specific value in cbo (1 Viewer)

Hi All -

I have frmInspection. I have multiple cbos within it.

cboOilCan offers the user the selections "yes" or "no." This is recorded in field "OilCan" in tblInspection.

If the user selects "yes" I would like a popup form (frmOilCanDetail) to automatically open to allow the user to enter more detail and data. The data from frmOilCanDetail will be recorded in tblOilCanDetail.

How can I go about this? I am sure it will require VBA which is fine - -just heads up - while I can typically understand VBA, I am not at all proficient with creating it and placing it.

Thank You for Your Help!

Tim

inspect the value of the combo on its AfterUpdate Event:

private sub combo_AfterUpdate()
If me.combo="yes" then
docmd.openform "frmOilCanDetail"
end if
end sub