Microsoft Access : Filter a combo box based on another CB selection ?

[SDK^]

Hi,

Can you please help me with the following problem ?

I have a form in MS Access containing a Combo box with the options 1, 2, 3, 4 and 5. When a user selects 1 or 2 I would like a second combo box to be populated with the number 1 and when 3, 4, or 5 is selected I would like the combo box to show the number 2.

How can I do this ?

Thanks

 

[WIBSBOT]

Look here....

http://office.microsoft.com/en-us/access/HA011730581033.aspx?pid=CL100570041033