Hi All,
New to advanced access techniques and need some help.
I have two combo boxes. 1) Leagues 2) Owners
I need the second combo box to update the values based on the selection of the first combo box. So if Andy and Amy are part of League A and Rick and James are part of League B and the selection made for the first combo box is League A, the second combo box should only list Owners Andy and Amy.
Is there someone who can help explain the process or point me to some tutorials? I am not sure what I need to reference etc...
I've tried referencing a query with fields league and owner with criteria on league pointing to the forms 1st combo box. The query works properly. I need "After Change" macro to refresh the query and then populate those values in the second combo box.
Hopefully this is an easy problem.
Thanks in advance!
New to advanced access techniques and need some help.
I have two combo boxes. 1) Leagues 2) Owners
I need the second combo box to update the values based on the selection of the first combo box. So if Andy and Amy are part of League A and Rick and James are part of League B and the selection made for the first combo box is League A, the second combo box should only list Owners Andy and Amy.
Is there someone who can help explain the process or point me to some tutorials? I am not sure what I need to reference etc...
I've tried referencing a query with fields league and owner with criteria on league pointing to the forms 1st combo box. The query works properly. I need "After Change" macro to refresh the query and then populate those values in the second combo box.
Hopefully this is an easy problem.
Thanks in advance!