combo will not show>

[John thomas]

Help please
I have a split form to display all my Invoices
Currently the underlying Query displays all Invoices
I Want a a combo box to display various numeric ranges .The combo Gets its ranges from a table where they are stored as text .
My prolem is that no matter what I try I can only get the combo to put a single number in the query criterior, eg ifI put 23456 or 34526 it will show that one Invoice but if I add >20
It shows nothing .If I manually insert >20 in the criteria of the query it works but just wont work when the combo gets >20 from the table and the query gets is criteria from the combo

 

[Ranman256]

Is the combo tied to a query? If so, make sure the comb is bound to the correct column.
Either way,qry or value list , the result query should have the params in the criteria.

Select * from table where [number] between forms!frmRpt!cboNum and (forms!frmRpt!cboNum+50)

 

[John thomas]

Dont fully understand what your saying
The combo is getting its values from a atable and i have code in the query criteria to get its criteria from the combo .i ihink i have this correct as it all works except when i add >to the number in the table

 

[CJ_London]

I think you are suggesting you have a combo with values like

<100
100
200
>200

and your query is something like

 SELECT *
 FROM myTable
 WHERE Somefield & myform!form!combo

if so, it doesn't work like that. Suggest clarify what you are trying to do - is this to populate a form or report? is the form already open?

if this is to build a filter for the current form, you can do

me.filter="somefield" & mycombo
me.filteron=true

but you will then need to add '=' to all the numbers - you can use >= or <= but not => or =<

 

[CJ_London]

or just a thought

me.filter="somefield" & iif(isnumeric(mycombo),"=" & mycombo,mycombo)

 

[John thomas]

The combo is on the split form that is open.This is the code in the query
[Forms]![Vew all Invoices]![Combo57]
As i say the combo gets its values from a table .
it all works until i put a > before the number

 

[CJ_London]

that is not code.

if you are unable to respond other than by repeating yourself and not building on what has been suggested I regret that as I'm not a mind reader I really don't have time to try to guess what you mean

 

[John thomas]

Sorry you see it that way . I am a novice and im doing my best to explain.
Thanks for your help anyway .

 

[CJ_London]

try this link - it should help you to explain your problem better

http://www.access-programmers.co.uk/forums/showthread.php?t=223418

 

[John thomas]

Hi CJ
Read the link
I will try to do better Next time
Many Thanks