I have a form where the user chooses the name of a country from a drop-down menu, and then all remaining fields on the form populate with values that correspond to that country.
I have a main table that contains all the country names and an ID# that is assigned to each country. The drop-down uses a command to check this table to pull each country’s info.
Also on the form is a button that, when clicked, queries from a different table that contains more information on each country, and displays this information as a list. The button has a label that does not change according to each country; it always says “Click to see list”.
However, there are 3 possible kinds of lists, and I’d like the button’s label to change depending on the kind of list. Instead of always saying “Click to see list”, I want the button to say “Click to see Blue List” or “Click to see Red List”. The main table with the ID#s does contain a field called “Type of List”, so the 3 possible values are listed there.
Is it possible to have the labels change on the one button depending on what country the user selects from the drop-down?
Or, would I need to have a different button for each kind of list, and replicate the VB behind each button?