How to exclude records in a query combo box

[Ray67]

Hello

I have a form where my users enter data. The form has one combo Box where my user would choice from a list. I would like to run a query that would exclude a word from the combo box.


If the combo box has three types of payment cash, check and credit card. I would like for cash to be excluded. So when i run query it would only gave me checks and credit card.


Thanks

[troggernaught]

Where is the combobox getting its data from? Do you always need to exclude cash or only sometimes?

Assuming your combobox is getting its data from a table and you always want to exclude cash, then you just have to modify the combobox's recordsource. For example, SELECT * FROM paymentmethods WHERE method<>'cash'

You'll have to provide more info to get a better answer, though.

[Ray67]

Troggernaught

Combo box is getting its data form a table. Yes i always need to exculde cash.

Thank you

[Ray67]

Sorry i really don't understand what i have to do. I'm new to access.


Thank you

[Ray67]

Thank you
I got it to work i used <>"1".

Thank you