Method or Data Member not found

[hockeylvr]

I cannot figure out what I have done wrong in this code.

I have a field "GPBuyerProjectID" in my query that my form is based on. I needed to simple change the name of this field from CCM Buyer to GP Buyer and I have changed it in every query/table I need to.

I have 5 other combo boxes just like this with different names and they all work perfectly, but, for some reason I am getting the message
"Compile Error" "Method or Data Member Not Found" on this one only.

I have checked my queries, my field list, relationships and it all matches up. The field is in the field list for the query on the form so I don't see how it can't find it.

When I go into VBA and type "Me." the list of available field names come up but "GPBuyerProjectID" and "GPBuyer" are not in it.

I have tried compact and repair with no luck and my deadline is past!

Does anyone know what might be causing this?

Private Sub GPBuyerName_BeforeUpdate(Cancel As Integer)
Me.GPBuyerProjectID = Me.ID
Me.GPBuyer = "GP Buyer"
End Sub

Thanks for your help!

 

[CautionMP]

Check the caption property for the field in both the table and query. In a lot of instances Access will add a caption to fields to 'help you out'. On more than one occasion I have tried to use the 'caption' when building SQL statements and get a whole host of errors because the caption is not the field name (even though it looks like it in datasheet view).

Hope this helps,
B.