Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Selecting using Combo boxes

Status
Not open for further replies.

techkenny1

Technical User
Jan 23, 2009
182
AU
Hi ,
On a form I have 2 combo boxes.One is used to select a company and the other is to select a department.
As most of the companies have at least 20 departments it becomes quite a problem to select the right department within the combo box as there are so many.
Is it possible that once a company has been selected that the department combo box will only show the departments for that company.
All companies in the table have associated with them an ID no and a biller code. Can either one of these be used to select the departments associated with it.
If so how can I do this.

Many thanks,

Kp
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top