Error retriving data from Access

[estronutz]

Hi

I have the following error when running this piece of code

Runtime error 3265

Item not found in this collection

Please Login or Register  to view this content.

I have the field "name" in both my Job table as well as my Customer table

How do I display the one in job? Job.name doesn't seem to work ...

Thanks a mil

[antoka05]

When you get an error referinf field with:

Please Login or Register  to view this content.

do so:

Please Login or Register  to view this content.

omitting the table name.

If in your select you do the double selection of the same name field, for instance:
select table1.Id, table1.Lastname, table2.Id, table1.OrderNum where table1.Id = table2.Id
in this case you will not get error refering rs("table1.Id") or rs("table2.id")

Regards,
Antonio