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

Not just filter, but only show certain data in a form record based on field selection

P: 3
I have a form that shows state/organization-specific data for professional licenses. The form shows both engineering information and architectural information, both the same types of fields (hyperlink to licensing website, renewal fee, etc.) for each genre (eng and arch.) I would like to have the form only SHOW the specific genre information based on a selection in a "Type of License" drop down field - if Registered Architect is chosen, I would like only the arch information to show, and if Professional Engineer is chosen, I would like only the Eng info to show. Is this possible?
Apr 26 '12 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 15k+
P: 31,494
Yes indeed.

If all the data is available but only some of it required in a particular situation, then hide the controls you don't wish to see depending on the condition.

This code should be enclosed in a single procedure and called both when the form is opened (Form_Open()) and when the record changes (Form_Current()).
Apr 27 '12 #2

P: 759
Technically, the answer for your question is NeoPa's solution.
But I think that is very hard (if not impossible) to design an elegant form. So, as an advice, go and design two forms.
Or use a TAB control.
Apr 28 '12 #3

Expert Mod 15k+
P: 31,494
It can all be done in less than ten lines of code Mihail, and six of those are the procedure headers and footers. Complex it's not.
Apr 28 '12 #4

Post your reply

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