Calling Fields!!

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:

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

Does the recordset have a Fields property. I am unfamiliar with data controls, but I assume that the recordset object is the same everywhere. If it has a Fields property, try...

VB Code:

cboCdId.AddItem Adodc1.Recordset.Fields("Main.CdId")

:)

That worked fine, thank you so much, you have helped me out so much :) thx again.



Ed.