Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1336
  • Last Modified:

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
0
perennial
Asked:
perennial
1 Solution
 
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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now