Compile error: Method or Data Member Not Found

Question posted by: Kenny G (Guest) on November 12th, 2005 07:40 PM

Hello,

Got a small problem:

I built a small table and used the following on my laptop this
morning.
This code compiled and worked fine on my laptop but when I compiled
the first Sub on my desktop I get compile error: Method or Data
Member Not Found
The words ProjectCode was highlighted.

Next I replaced the period with a bang just before the words
ProjectCode and it compiled just fine. When I depress the F8 key to
copy the previous record I get Runtime error 2465 Microsoft Access
can't find the field ProjectCode.

I sure would appreciate your help.

Kenny G

1...
Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyF8 And Me.NewRecord Then
CopyFromLast
Me.ProjectCode.SetFocus
End If
End Sub

2...
Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyF8 And Me.NewRecord Then
CopyFromLast
Me!ProjectCode.SetFocus
End If
End Sub

Quote | Subscribe