Hi All,
I am new to Access and I am hoping that someone can help me with an issue. I have a Table with two fields named "Type" and "Category". Both fields are to be dropdown lists and I want to have it so that the value that is selected in the "Type" field will determine the values that show up in the "Category" field dropdown list.
I know that I need to create a AfterUpdate macro that sets the Row Source for the "Category" field based on the value selected in the "Type" field. But I cannot figure out how to actually write the macro in Access 2016 so it does just that and I can't find any examples that illustrate how to do this. So I am hoping one of you folks might be kind enough to guide me in the right direction!
A bit more info: there are 4 possible values that can be selected in the "Type" field, and each one of those have the data for the "Category" field list in separate tables.
Let me know if any more info is needed.
Thanks for all help!