I am trying to synchronise 2 combos and having very little success. I have a contracts search form displaying legal terms in a tab control of about 20 diff pages and the suppliers details at the top of the screen. I want the user to make the following selections

Combo 1: choose their selection ie search for existing contracts or search the archive for expired contracts. I have this behind this combo

SELECT DISTINCTROW [tblSelection].[SelectID], [tblSelection].[Description] FROM tblSelection;

2ndcombo - Is a two column combo taken from two diff tables ie supplier name from supp table and the contracttypedesc from contract type table. Now I want the 2nd combo to ONLY display contracts based on the first combo selection. Here is what I have taken from my query:

SELECT DISTINCTROW [QrySearchContractTerms].[Order No], [QrySearchContractTerms].[Company], [QrySearchContractTerms].[ContractTypeDesc], [QrySearchContractTerms], [SelectionID] FROM QrySearchContractTerms WHERE ((([QrySearchContractTerms].SelectionID)=[Forms]![frmTermsandConditions]![cbo491]));

I keep getting errors the minute I try to choose anything in my 2nd combo and it always displays blank. Can anyone help with this? Believe it or not I am looking at an example of 4 combos doing exactly this which I downloaded from the internet and I still can't get it to work.

Thanks for any help
Hayley

Managed to crack it at long last that was driving me nuts!!

Thanks again
Hayley