Compile Error: Method or Data member not found

M

mikefitzge

Hi,

I'm getting "Compile Error: Method or data member not found" when I
call the below function. The debugger is highlighting the part of my
code that is in all caps. lngVCT4RampSurvey is in the query that is my
form's record source and it is a field on my form. I tried changing
the period after the Me to an exclamation point (even though I
shouldn't have to) but that didn't work either.

What really got me was that when I simply deleted Me.lngVCT4RampSurvey
from the code the debugger just said it couldn't find the next object
down the line, Me.lngVCT4Survey.

I'm calling this function on the OnClick command of a button using
"Call WardConcOSR"

Any help is greatly appreciated.


Public Function WardConcOSR()

Me.lngCurbLengthSurvey = Me.lngCGT3Survey + Me.lngCGT3RampSurvey +
Me.lngVCT4Survey + ME.LNGVCT4RAMPSURVEY
Me.lngFlatworkSurvey = Me.lng5SidewalkSurvey +
Me.lng5SidewalkRampSurvey + Me.lng8DrivewaySurvey +
Me.lng8DrivewayRampSurvey + ((Me.lngDWAlleyConcreteSurvey) * 9)

If Me.ysnHold = False And Me.lngPhaseID = 10 Then
Me.memWardComment = "Survey: " & Me.lngCurbLengthSurvey & " ft.
curb, " & Me.lngFlatworkSurvey & " SF flatwork. " & Me.memOSRComments
End If

End Function



Thanks,
Mike
 

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

Method or Data Member Not Found 4
Calling Error Handling in VBA 0
Compile Error: Method or data member not found 3
Compile Error: Method or Data Member Not Found 1
Mac Excel compile error method or data member not found 0
method or data member not found 5
Calling Error Handling in VBA 0
Data Member Not Found Error on Compile 1

Top