Populating a drop down list (attempt # 2)

  • Thread starter Thread starter GLT
  • Start date Start date
G

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.
 
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 ...
 
Back
Top