Hide value from Column in Combo Box

[g@v]

Hide value from Column in Combo Box [SOLVED]

Hi,

Had a search and found this...

http://www.access-programmers.co.uk/forums/showthread.php?t=99682&highlight=hide+combo+box

Not very clear to me what I'm trying to do is say I have a field called "number" the the value in those fields are 1, 2, 3, 4 how would I hide say 2 and 4 from the combo box shown on the drop down combo box in the form...

Thanks in advance guys(and girls )

 

[Dreamweaver]

In the query that feeds the combo use a limiting criteria of "<>2 and <>4" for the field number but I would change that field name as it may be a reserved word in access

 

[g@v]

Thanks for the quick reply this is what I used...

<>"2" And <>"4"

And that now doesn't show them in the combo list, the above was a example not what I was actually using as data.

Thanks again