Populating a drop down list (attempt # 2)

[GLT]

Hi,

I have a drop down list (list of clients) that the user can select from.

I have a second drop down list, where I want the servers that belong to the
client that was selected from the first drop down list (above) to be
displayed.

The second drop down box uses the following SQL:

SELECT tbl_Perm_ServerName.ServID, tbl_Perm_ServerName.Client,
tbl_Perm_ServerName.ServName
FROM tbl_Perm_ServerName
WHERE
(((tbl_Perm_ServerName.Client)=[forms]![frm_ServBackupNam]![cmb_Client]))
ORDER BY tbl_Perm_ServerName.ServName;

When I run this SQL, it show the clients in both dropdown lists - can anyone
advise what is wrong with this SQL?

Cheers,
GLT.

 

[Wayne-I-M]

Can you post the sql for the 1st combo as well.

 

[Steve Schapel]

GLT,

You need to check the properties of your combobox. In particular the
Column Count and Column Widths properties.

Alternatively, at a rough guess, I suspect you might get what you want
by changing the order of the fields in the Row Source query, like this...
SELECT tbl_Perm_ServerName.ServID, tbl_Perm_ServerName.ServName,
tbl_Perm_ServerName.Client ...