Need to show data after a random text label in combobox is chosen

[ian87]

Hi everyone,

I need to have a query expression where it shows data based on what i choose in a combobox. This is simple when you simply want to filter a combobox based on values you already have but I am adding new labels in my combobox which do not relate directly to field titles or values.

Combobox values=

N.America
US (already a field in table for US revenues)
Canada (already a field "")
L.America
Mexico(already a field "")
Argentina(already a field "")

The problem I am having is when I select "N.America" in the combobox there is no direct relationship. Can somebody tell me what the SQL/Expression would be to say for example

WHEN Combobox12.Testgrowth= N.America, SHOW US AND Canada (<- both fields)

My other part of the question is where do i type this in the query box?

 

[jdraw]

I urge you to watch the free video tutorials at
DataPig to see what combo boxes are and how they can be used

http://www.datapigtechnologies.com/flashfiles/combobox1.html

I would suggest that you create a Table of the location values you are dealing with. You could use these to populate your combobox.
You could use a filter/query to select the records from your data that match the combobox value.

You may want to visit http://www.allenbrowne.com/casu-22.html to see additional Access tips and techniques

Let us know how .you make out.