By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,863 Members | 879 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,863 IT Pros & Developers. It's quick & easy.

Compile error: Method or Data Member Not Found

P: n/a
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
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.