Combo Box contents depending on prior combobox

[TomJamieson]

Hi

I have a form that is basically an autoform for inputting into my main table. I have one combobox that has customers in it.. let's call them a b and c. Further down is another field, called Reference. Each customer can have certain references. I want the reference field to be a combobox, in which the selection list is dependent on the choice in the customer combobox.

So if customer is a, the ref. cbo gives you the choice of 1, 2, or 3. If Customer is b, ref is 4, 5, or 6, and if customer is c, ref is 7, 8, or 9. See what I'm saying?

Sorry if it's not explained very well, I am happy to answer any questions to clarify it.

Thanks.

 

[Banana]

First things first.

Search the forums on "Cascading Combobox" There's a sample database showing how it works in Sample Database forums. Take a look at it then come back when you have more specific question.

If you already did, I'll have to ask you to be more specific on how you intend to filter the second combobox; I'm not seeing any logic in selecting 1,2,3,4,5,6 for a,b,c,d.