Possible VB syntax error after comverting Access 97 to v2003.

[stanhilliard]

I converted a database file from Access 97 to v2003 and it seems to be working except it flags one statement. With a breakpoint on the statement:


Public Function FindWithSQL()

execution does not stop at the breakpoint but flags the statement:


Forms!frm1FindOpt!ListFiltered = myRS.[LN]

That statement works correctly in Access 97.

Q1: Why doesn't it work in 2003 and how should I correct?

Q2: If the problem involves VB syntax, is the a link to a list of similar changes?

[stanhilliard]

More information:
I retyped the line and now when try to run, an error message says "Method or member not found."
The ".[LN]" is highlighted

Correction: "Method or data member not found."

[stanhilliard]

Never mind. I fixed the problem myself by changing ".[LN]" to "![LN]" .