I'm fairly new to Access 2007. I'm an ERP functional consultant with programming experience close to none.

I'm setting up an Access database for personal use. Let's say I have product categories as Male, Female, Unisex. I have product colors as black and white. When entering an order, I select a color (combo box) i.e black and then gender (combo box) i.e male. In the order form gender can be either male or female but not unisex.

In prodcut id field (combo box) I need to see black items with male and unisex gender.

When I set up the query in product id combo, the OR operator precedes the AND operator, then I see white items too. As a result I see all the male and unisex items.

I couldn't find a way put an OR operator within an AND operator so to speak.

I changed my approach and instead of placing Male, Female, Unisex in one field, I created two checkbox fields, Male and Female. This time I tried to query Products.Male=True if GenderCombo=Male, Products.Female=True if GenderCombo=Female along with color but no luck.

Thank you very much for the answer. I tried what you said, using inner brackets earlier. Somehow it didn't work. I deleted the field and recreated it and tried again and it worked now. Maybe I omitted something then. A rest may be useful sometimes :) Thanks again.
–
Bekir KATRANCIJan 1 '13 at 13:31