The expression you entered has a field, control, or property name that Microsoft access can’t find

I have the following statement; When I open the db I get the following error:

"The expression you entered has a field, control, or property name that Microsoft access can’t find"

I can't seem to find what is wrong with it?

Any help is much appreciate



Private Sub Form_Current()
 
If Not IsNull(Me.DatSowd) Then
Me.WkGoal = DLookup("WkGoal", "tblSS", "ISNo='" & Me.ISNo & "' And DatSowd=#" & Me.DatSowd & "#")
End If
 
End Sub
LVL 1
perennialAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
try
Debug>Compile and see  which will be highlighted on error
0
 
perennialAuthor Commented:
I see my mistakes, Thanks Capricorn1.

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.