drop down problem.

[buggy2]

I have generated a form based on one table. it contains 3 combo boxes the first lets the user select the date of the info, the second selects the area and the 3rd contains all the a number of fields (selected field names for the same table) that relate to info. At the moment i am running a query using

[Forms]![myform].[Form]![mycombo]


but when I enter it in for the 3rd combo box it is returning the field name.


eg. combo1 = march 2003

combo2= london

combo3= units sold


When I run this it gives me entries |march 2003|London| and what was selected in combo3 in text (not the value).
In this case it will give:

date | Area | value

march 2003 London units sold
march 2003 London units sold
march 2003 London units sold
" " "

what i need is to query using the value:

date | Area | value

march 2003 London 24
march 2003 London 12
march 2003 London 25

 

[buggy2]

combo box

the only solution i have at the moment is to use nested if statements and seperate docmd.runsql or runquery statement for all but this will build up to alot of queries.

if combo1.value="a" then
docmd.runsql "statement"
elseif combo1.value="b" then
docmd.runsql "statement"
.......................
end if

where a and b are fields in my table