Question Passing Combo Box option in a Query Criteria Field

[npatil]

Hello,

I am currently using these lines for extracting a ">" value in one combo box to "value" from another combo box.However. I would like to use only 1 query and pass the combo box options to the query I create to get my results.

This is what I am using currently for >=, similarly for < and so on..

SELECT List.Feld3, List.Feld7, Mid([Feld3],((InStr(1,[Feld3],"/"))-3),3) AS Expr1
FROM List
WHERE (((Mid([Feld3],((InStr(1,[Feld3],"/"))-3),3))>=[Forms]![Filter]![Text23]) AND ((InStr(1,[Feld3],"/"))>3))
ORDER BY Mid([Feld3],((InStr(1,[Feld3],"/"))-3),3);

I tried the following:

SELECT List.Feld3, List.Feld7, Mid([Feld3],((InStr(1,[Feld3],"/"))-3),3) AS Expr1
FROM List
WHERE (((Mid([Feld3],((InStr(1,[Feld3],"/"))-3),3))=[Forms]![Filter]![cmb_tw_sel].[Text]+[Forms]![Filter]![Text23]) AND ((InStr(1,[Feld3],"/"))>3))
ORDER BY Mid([Feld3],((InStr(1,[Feld3],"/"))-3),3);

However, this is not working. Can you guys suggest me the correct syntax?

Thanks,