Populate List Box via two Combo Box

[RhysPhelps]

hi guys and girls,

What i have is a list of account codes, and a list of cost centres. Each combination of these (so for example "5030" and "Externals") will have it's own budget reference sperate form another (so 5030 externals would have a different budget from 5030 software etc)

i have a form ("Form1") that has two combo boxes ("Cost" and "Account") that i would like to use to populate the list box ("Ref"). The table is "BudgetRef" I have the query currently set at:-

SELECT BudgetRef.Budget_Reference, BudgetRef.Account_Name, BudgetRef.Cost_Center
FROM BudgetRef
WHERE BudgetRef.Cost_Center=Forms!Form1!Cost

so that the "Cost" combo correctly populates the "Ref" list box. how would i go about adding the 2nd combo ("account") to the query? i've Tried to add AND in the WHERE but it returns a blank list box.

Oh and i've added the .requery on the combo changes so i dont think t is that.

Any help would be great

Thanks

[ChipR]

You should be able to add to the Where clause, but assuming Account is a text field, it needs to be in quotes. Maybe something like:

"SELECT BudgetRef.Budget_Reference, BudgetRef.Account_Name, BudgetRef.Cost_Center
FROM BudgetRef
WHERE BudgetRef.Cost_Center = " & Forms!Form1!Cost
& " AND Account = """ & Forms!Form1!Account & """"

[NeoPa]

Assuming the Account_Name field is the one that holds the data to match your Account ComboBox then :

SELECT Budget_Reference,
       Account_Name,
       Cost_Center
FROM   BudgetRef
WHERE  Cost_Center=Forms!Form1!Cost
  AND  Account_Name=Forms!Form1!Account