conditional display of subform

[JCemcity]

When a user selects the "No" choice in a pulldown list while entering info into the main form, I want it to trigger the opening of a subform for the user to enter detailed data. Is there a way to do this? thanks! Jon

[George Oro]

If me.YourChoicePu lldownName.valu e = "No" then
docmd.openform "YourFormNa me"
else
'In case you have some condition if Yes
end if

Your saying its a subform, so subform is attached to a form and always open. I assumed your subform is another form.

HTH,
George

When a user selects the "No" choice in a pulldown list while entering info into the main form, I want it to trigger the opening of a subform for the user to enter detailed data. Is there a way to do this? thanks! Jon

[NeoPa]

George's code should be put in the AfterUpdate event of the ComboBox control.