Item not found in this Collection

[kmrowlan]

I am getting this debug message when I try to capture the recordset on some of the data from the table. I get the information if the data is a number, but not if it is in another format - ie text or other.

What do I need to do to fix this?

Example code is:
strCLS1 = rst![Buyout_CLS1]
strPartNo = rst![Buyout_PartNo]
strClass = rst![Buyout_Class]
strDescription = rst![Buyout_Description]
strImage = rst![Buyout_Image]
sinPrice = rst![Buyout_Price]

Buyout_PartNo and Buyout_Price come thru - they are numbers.

 

[Norie]

Are you sure you the field names are correct?

No trailing/leading spaces anywhere?

That's far more likely to be the problem, I can't actually see the data type being the cause.

 

[boblarson]

I can't actually see the data type being the cause.

That is completely correct. The error "Item not found in this collection" means that you are referring to a field and Access can't find it. So it is either being referred to incorrectly or the field wasn't included in the SQL Statement that the recordset is based on.