I would like to have a field display only certain information in a combo box based on what is selected in a previous data field.
The first fields is "Highest Degree Level Obtained" which contains the options of Associate's, Bachelor's, Master's, Doctorate's, and Certification. Based on the selection, I want "Degree Earned" to display just those types of degrees offered. The degrees are in a separate table called "Degrees" and each type of degree is in its own field labeled accordingly.
If I just have all degrees listed at once, this is the Row Source formula: SELECT [Degrees].[ID], [Degrees].[Degrees] FROM Degrees;
I am thinking it would be something like this:
SELECT [Degrees].[ID], [Degrees].[Masters] FROM Degrees IF SELECT [Information].[Highest Degree Level Obtained] = "Master's";
How far off am I or is this even possible?
Thank you.