473,383 Members | 1,859 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,383 software developers and data experts.

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

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
3 2540
NeoPa
32,556 Expert Mod 16PB
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
Mihail
759 512MB
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
NeoPa
32,556 Expert Mod 16PB
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

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

Similar topics

5
by: MX1 | last post by:
Here's an interesting one. I have a database that has user level security invoked. The design is normalized and I have one field in particular called Rep ID. Any thoughts on how I can allow all...
2
by: John Baker | last post by:
Hi: I have a sub form which i would like to show all the records selected from a table. There may well be over 100 of them. For reasons I cant fathom, the form will only show six, and then...
1
by: Sue | last post by:
I have a main form based on a member list, so that I can add details. I also have a query which takes its parameters from a textbox on the form to search for a surname so that I can delete the...
1
by: theseandavis | last post by:
I would like to combine two of my tables into one: Task 1 - Forecast - # Task 1 - Plan - # Task 1 - Actual - # I have two tables, each with values for Forecast, Plan, or...
0
by: bay_dar | last post by:
I have an ASP.NET application with vb that I would like to use a confirmation box with, but only if certain conditions are met. In my case I would only want this msgbox to show up if a user entered...
1
by: xixi11 | last post by:
Hi I wanted to sum data in one field and output the data in another new field. For example, my data item is like this: clientId form location value 1111 1 2 22.5 1111 ...
2
by: mnms | last post by:
Hi, I'm trying to create an "overview" form. And I haven't been able to figure out how to get Access to do what I want yet. Basicly what I want, is to populate a subform based on a field...
4
by: kdubble | last post by:
Hi I am trying to get the results of a query to show only unique student records (not duplicates). Is there a simple way to make the criteria field do this? I am not too familiar with SQL. ...
4
by: Prodian | last post by:
Im trying to parse a recv from a telnet session then only grab certain data. Heres an example of the recv that Im storing into a string: Internet 204.189.124.205 0 001a.a01f.4e5a ...
3
by: steveninfl | last post by:
Hello , I am using MS Access 2000. I have a Table called Transactions, I have created a form for this table, one of the fields on the form is a combo box with the row source type as value list. In...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.