Help with a query from a drop down box

[lehi53]

I am trying to create a query to pull people in who fall on a certain date but do not have certain keywords. The keywords come from a combo box. Please see the attached table for help. Look at the actions tab. The bottom right sub form which is expiring today.

[June7]

What combobox?

[lehi53]

What combobox?

Sorry. the combo box is on the table CG info. The field is called Hotness. That field pulls from another table called level of hotness. Unfortunately this is how I built it. I know its not ideal.

[June7]

How do you expect this combobox on table to help filter records?

I NEVER build lookups in table. The actual value in the field is number, not the descriptive alias. So if you want to apply filter criteria to this field, parameters must be the number values.

[lehi53]

How do you expect this combobox on table to help filter records?

I NEVER build lookups in table. The actual value in the field is number, not the descriptive alias. So if you want to apply filter criteria to this field, parameters must be the number values.

.
This is what I meant by I didnt do it right. But where we are right now I have to leave it. Based on that, how would I build a query using the numbers you talked about. I want to say Not 5,6,7,8 or whatever.

[June7]

Exactly what criteria do you want? Should be simple task with the query builder.

If you want to apply filter to the subform RecordSource, that is another issue.

Options are dynamic parameterized query as the RecordSource or code to set the Filter and FilterOn properties.

The Master/Child Links properties of the subform container controls are not set. Should they be?