Compile Errors : Me ?

M

Mauricio Silva

I am trying to compile a database I am converting from A97 to A2K. In
several reports I get the same error message: Compile Error in lines like
this:

If Not IsNull(Me.TermDate) And (Me.FundSales = 0) And (Me.Sales = 0) Then
Cancel = True

in this case Highlighting .FundSales. Here is the case: This object exists,
it has the same name as the field but if I change the name, the same thing
happens. I tried:
Me!FundSales => It highlights !FundSales as the problem
Me.Controls("FundSales") => It highlights .Control as the problem
Me("FundSales") => It highlights Me as the problem

When I type Me. , the FundSales appears as an option but the module still
does not compile.

I am totally lost. Can somebody help?

Thank you in advance

Mauricio Silva
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Compile error in table level validation expression " after format 0
How do I set focus (and select text) on a text box on a modeless userform? 0
Word doc keeps changing to ALL CAPS 0
Compile Database Code Problem 9
Compile error- Invalid use of property 2
compile error 1
Solver Compiler issue 2
"me" keyword error while compile 1

Top