By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,471 Members | 2,264 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,471 IT Pros & Developers. It's quick & easy.

conditional display of subform

P: 1
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
Jan 11 '07 #1
Share this Question
Share on Google+
2 Replies


P: 36
If me.YourChoicePulldownName.value = "No" then
docmd.openform "YourFormName"
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
Jan 11 '07 #2

NeoPa
Expert Mod 15k+
P: 31,186
George's code should be put in the AfterUpdate event of the ComboBox control.
Jan 11 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.