Using Access 2010 I am trying to produce an interactive demonstration of data to clients who are interested in staffing numbers and details across Europe. Rather than using visio / power point I am using access so I can reuse this time and again with the end user simply producing excel spread sheets in the right format that get imported / linked into access.
I have produced a map which resides in a form, using transparent command buttons when the user clicks on a country a list box pops up with the names of their competitors. That was the easy part - I am keen to apply a filter to the list box from that command button.
The list box is called “Offices” and contains 2 fields: “Company” and “Country”. (“Country” is hidden from view). So for example when I click on Spain the list is filtered by all companies whose “Country” = “Spain”
Can anybody help?