2nd Combo box gets only the first record

[Sahil]

I have two combo boxes (Vendor & System) on my form. If I select a
particular vendor from the combo Vendor, then the second combo System should
get the list of all the systems for that Vendor. But currently if I select a
particular Vendor it fetches only the name of the first System (first record
only) in the System combo box though that vendor has more number of systems
corresponding to it present in the table.

Please help.

 

[Golfinray]

First try Martin Green at www.fontstuff.com and Allen Browne at
www.allenbrowne.com
Both have good stuff on what you are trying to do.