ListBox

[Wallie]

Okay,

Ive got 2 tables, one with companynames and some of their info en a table with employees. I have a form where a complaint can be written out. One had to select the company and an employee who works at that company. So when you select a company I want te have the corresponding employees in another ListBox.
How can I do this ?

Tx

 

[Jack Cowley]

This article relates to Combo boxes but the principle applies to your need as well.

http://support.microsoft.com/support/kb/articles/Q209/5/76.ASP?LN=EN-US&SD=gn&FR=0&qry=q209576&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000