Populating a drop down list (attempt # 2)

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.
 
S

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Excel: How do I put a formula in a drop down list 11
No Data in Drop-Down Lists 6
Drop Down List Position on Form 2
Drop Down in Form View 3
Drop-down list to select relevant reports 2
Access 2007 - Table A lookup values based on Table B 1
Limiting a drop-down list of reports 2
Variable drop-down list? 3

Top