My problem is that I need the contents of a dropdown box to change based on a previous selection in a different dropdown box.
More specifically I have a table with 2 fields, Project and Program. There can be Programs with more than one Project associated and there can be different Programs with the same Project Name. The first dropdown asks for the Program and I want the second dropdown to give the options that are associated only with that Program.
I'm assuming I need to use the AfterUpdate Event and some sort of If-Then or Select case, but I'm not familiar with how to do that using VBA.
Can anyone help?
Thanks,
G
More specifically I have a table with 2 fields, Project and Program. There can be Programs with more than one Project associated and there can be different Programs with the same Project Name. The first dropdown asks for the Program and I want the second dropdown to give the options that are associated only with that Program.
I'm assuming I need to use the AfterUpdate Event and some sort of If-Then or Select case, but I'm not familiar with how to do that using VBA.
Can anyone help?
Thanks,
G