How to link combobox to populate another combobox?

[HYKE]

Hi,

This is my first time in this board (MS ACCESS). I am trying to learn independently. I am working on a work project where my data has grown so big that keeping it in excel is no longer practical (as the file is now heavy and it contains years of records). I have been informed that MS ACCESs can hold larger file/records than excel. Anyway, I have already created a form into which I have a combobox1 that populates thru rowsource. In this combobox1 I have 3 list (suppliers).I have 1 more combobox (combobox2) into which this comobobox1 is related. Is it possible that when I choose supplier1 in combobox1, the combobox2 will be populated by products being sold by supplier1 and so with supplier2 and supplier 3? (I have a table with supplier1's products and tables of products for supplier's 2 and 3). Can somebody help me on how to do this...

Thanks,

HYKE

 

[alansidman]

You are referring to cascading combo boxes. Look at this link for a tutorial on how to make it work.

http://www.fontstuff.com/access/acctut10.htm

Alan