Combo Box

[kft10]

Hi all,

I have combo box contains client_code, client_name and program. I'd like to
eliminate the list based on the program that I entered before. Here is the
list:
Client_code Client_name Program
0001 Andrea Ali abc
0005 Ron Ajemian aaa
0003 Andy Gip abc
0004 Loren Yip zzz
0007 Gloria Yip abc

So If I input the Program field, let's say program 'abc', when I click the
drop down menu, the combo box will give me the list for client Andrea Ali,
Andy Gip and Gloria Yip only.

Is anyone can give me idea? Thank you in advance.

Rgds,
KF

 

[Klatuu]

Filter the Client Combo based on the value of the Program Combo:

SELECT Cliend_Code, Client_Name FROM YourTable WHERE Program = cboPrgram;

Then in the After Update event of the program combo, requeryy the client
combo.

 

[kft10]

It works, thank you...

Filter the Client Combo based on the value of the Program Combo:

SELECT Cliend_Code, Client_Name FROM YourTable WHERE Program = cboPrgram;

Then in the After Update event of the program combo, requeryy the client
combo.

Hi all,

[quoted text clipped - 16 lines]

Rgds,
KF