Hi

I have the following error when running this piece of code

Runtime error 3265

Item not found in this collection

query = "SELECT * FROM Job j, Customer c WHERE j.custID = c.custID AND c.custID = 10" 

Set rs = db.OpenRecordset(query)
   
   Do While Not rs.EOF
   customerNameBox.Value = rs("Job.name")


   rs.MoveNext
   Loop
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