Query Combo Box

[gus318]

Hello. I have worked a bit in Access and I am having some trouble with a query that I am working on. I have a combo box that has 4 items listed in the box. One of them is "In Kind" in the "Payment Type" field. I wanted to add a Criteria to the query (filter) that would just return the "In Kind" Selection and of the combo box to pull the records. I can put a filter on it after the query is run that show all the "Payments Type", but I want to use the query Criteria to get the results. Thank you

 

[John Big Booty]

Welcome to the forum.

In the criteria of your query use;

[Forms]![YourFornName]![YourComboName]

 

[gus318]

Thank you, but I have not been able to make it work. I am unsure of the actual naming convention, sorry. So, do I use [In Kind]![Payment Type]![In Kind]

Name of the Query=In Kind
Name of the Combo Box= Payment Type
Name of the Payment Type in the combo box I want to only see= In Kind

Sorry to be so basic.... gus

 

[John Big Booty]

The first portion is static the second two should reflect the reality of your DB;

[Forms]![YourFormName]![YourComboName]

Place this in the criteria grid of your query (whilst it is design view) of the field you wish to query relevant to the combo.

Have a look at the attached sample, for a practical example.

 

[gus318]

Thank you again John. I do not want to make a selection from the actual pull down (Combo box)on the Payment Type. I would like the query to open with the filter already set....

I have Payment Types:
Cash
Credit Card/Debit
Check
In Kind

I want the query to ONLY return the In Kind records.

Thanks again, gus

 

[John Big Booty]

In that case I'm not sure I understand where the Combo Box is coming into things