Evening all,
I have a combobox displaying guest types. The row source is from a table called 'tbl_guesttypes'. The values are:
[PK] [GuestType]
1, Royals
2, Heads of State
3, Premiers
4, Governors
5, Heads of Department
6, Ambassadors
7, Prime Ministers
I would like to limit this list depending on the value of a textbox on another form (which is always open and never visible to the user). The value is a country category chosen by the user when navigating through the menus. They are:
European Heads of State
Other Foreign Heads of State
Royal Head of State
Heads of Department
Not invited
etc
So for example, if a user has chosen the European Heads of State category I would like the combobox to only show those guest types pertaining to that category. Say Royals, Prime Ministers and Ambassadors.
If they choose Heads of Department I would like the combobox to be limited to just the Heads of Department guest type. And so on.
I have absolutely no idea how I would structure this in a table (or two tables?) I will continue searching online but if anyone could offer up any help I would really appreciate it.
Thanks in advance.
David
I have a combobox displaying guest types. The row source is from a table called 'tbl_guesttypes'. The values are:
[PK] [GuestType]
1, Royals
2, Heads of State
3, Premiers
4, Governors
5, Heads of Department
6, Ambassadors
7, Prime Ministers
I would like to limit this list depending on the value of a textbox on another form (which is always open and never visible to the user). The value is a country category chosen by the user when navigating through the menus. They are:
European Heads of State
Other Foreign Heads of State
Royal Head of State
Heads of Department
Not invited
etc
So for example, if a user has chosen the European Heads of State category I would like the combobox to only show those guest types pertaining to that category. Say Royals, Prime Ministers and Ambassadors.
If they choose Heads of Department I would like the combobox to be limited to just the Heads of Department guest type. And so on.
I have absolutely no idea how I would structure this in a table (or two tables?) I will continue searching online but if anyone could offer up any help I would really appreciate it.
Thanks in advance.
David