combo box problems

[jerbacher]

Hello everyone,

I have a form titled "frmInstallationAudit". On this form are two combo boxes. In the first combo box are company names which are pulled from the table "tblCustomers". In the second combo box, I wish to display a list of contacts which relate to the company chosen in the first box. These contacts are pulled from the table "maillist". I understand that I need an SQL statement on the second combo box. I have this. The query builder displays the fields: Name, from Maillist; Company, from Maillist; and Company, from tblCustomers. the SQL statement is as follows:

SELECT Maillist.Name, Maillist.Company, tblCustomers.Company
FROM Maillist INNER JOIN tblCustomers ON Maillist.Company = tblCustomers.Company
WHERE (((Maillist.Company)=[Forms]![frmInstallationAudit]![Company]));

Does anyone have any idea why the second combo box is blank?
Thanks a lot, any help is appreciated.

 

[Hayley Baxter]

Have a look at this sample it might help.

Hay

 

[jerbacher]

Thank you, but unfortunatly the company I work for has a firewall which doesnt allow me to view that page, sorry. Maybe if you could email that file to me at jon.erbacher@dometicusa.com, i think i might be able to get it that way. thank you!

 

[Hayley Baxter]

I could email it to you whats's your email and are you using access 97 or 2000 the copy I posted is in 2000 but here's a 97 version for anyone who's interested.

Hay

 

[jerbacher]

jon.erbacher@dometicusa.com access 2000

 

[Hayley Baxter]

I sent this to your email Jon let me know if you have any problems receiving this.