Querying more than one field at a time.

[Chyld]

Right, As earlier, I have 4 comboboxes, the first one selects a product and the other 3 select variances based on that product selection, i.e. size, colour, domestic or commercial etc.

Form 1

Prod Name Prod Type Prod Size Prod Colour
--------- --------- --------- -----------

Now underneath I have a subform which is requeried after the last combobox is updated.

The subform has three text boxes based on a query that uses the above 4 comboboxes as criteria and tells people how to react to certain product selections.

Inform Link Sell Manufactured
------ --------- ------------
What to do Another Product **any locations**

**any location** is where I get stuck.

I want the third text box to tell people where the product is manufactured BUT, that depends on their postcode (Variance in product colour shade etc...)

I have another table set up for that one with columns like

postarea product 1 product 2 product 3
-------- --------- --------- ---------
hx3 Scotland Wales England

I will have to link the subform query somehow to the above table but unsure on how I should do that.

Any ideas anyone?

I've got an idea but it doesn't work.....

Chyld