Well the problemt that i am having is i have a Field in my database called CdId,
and two tables which are inner joined together have the same Field which is my Primary Key. So when i Inner Join them they would be such as

Main.CdId
Info.CdId

so what i am doing is this

VB Code:
  1. cboCdId.AddItem Adodc1.Recordset!Main.CdId

but its giving me an error.

It Highlights the .CdId with "Method or Data Member Not Found Error"

Any suggetsion? or is there another way i cam call them instead of using !. Thx for you help