I still can't get it to open (forms list forms)

[hrg]

As i have made the query. I only get one company name and when clicking on it, it opens another contact record i think it has to do something with the fact that it is not filtered. But i still can't make it work.

Thanks

refer to my early posted message (before this posting).

 

[Alcar]

Listbox1.RecordSource = "SELECT * FROM Contacts WHERE " & _
"Contacs.Contact_ID = Company.CompanyID"

or whatever relation you have between the tables.

HTH

 

[Alcar]

Listbox1.RecordSource = "SELECT * FROM Contacts WHERE " & _
"Contacs.CompanyID = Company.CompanyID"

or whatever relation you have between the tables.

HTH