Ok, so, what I know of Access I've pretty much taught myself but VBA is a beast of thing to learn. The problem is, not knowing VBA in and out really limits what you can accomplish in Access.
The issue I have is I have a combo box bound to a table (Conrtol Source - Main Table, which of course is the Record Source for the entire form) and bound to another table (Row Source - lookupmedium). I also have another combo box bound to the same table as the other one (Control Source - Main Table) but I want to change the Row Source based on the selection made in the first combo box mentioned.
For example:
When the user selects TV from the first combo box I need the second combo box to list only the options that are TV stations
e.g. user selects TV from combo box one and the second combo box uses the the subLookupTV table as it's Row Source so that only TV stations are shown.
or the user selects Radio from combo box one and the second combo box uses the subLookupRadio table as it's Row Source so that only Radio Stations are shown.
I already have the tables built that will only contain radio stations or only contain TV stations and so forth. Just need the piece of code to link them all in that way. I assumed it might be an "IF-THEN" code or a Select Case code but it's hard to say.
Thanks!