Invalid use of the .(dot) or ! operator or invalid parentheses

[PLHarts]

I have been using the same VB code for over a year and now I am getting the above error on one PC. Other PC's do not receive the error. I have narrowed the problem to this one line:

Y = Me.PREFIX

When that line is remarked out, I do not receive the error. I have verified I have the needed references. Any suggestions on other places to look.

 

[RuralGuy]

But have you *refreshed* those references? Access Reference Problems

 

[PLHarts]

I refreshed the references. It worked!!! Thanks for the help.

 

[RuralGuy]

Excellent! You are welcome and glad we could help.

 

[doulostheou]

Just wanted to say thank you. This post solved my problem on two separate occasions. I was scratching my head about the error on both occasions not thinking that I had transferred the database from one version of Access to another and that the references might be thrown off. This post is a great reminder (and a top google hit); so again, thank you.

 

[RuralGuy]

Thanks for taking the time to post.