populating combo boxes

[moose]

i have a form with three comboboxes on.
the 1st one gets its data from customer name.
what i would like to do is select the customer in combobox 1, and then it will only populate combobox 2 with the products for that customer and the 3rd one to only populate with the relevant ref number
any ideas please

thanks in advance

 

[raindrop3]

Hello,

I should make 3 queries.
In querie 2 type in the criteria field from customer something like [forms]![youform]![combobox1]

Combobox 2 (rowsource querie 2) shows al the relevant info for the customer selected in combobox 1.

Hope this get you started.

Greetings,

Albert