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

Error 2465

P: 25
If IsNull([Temp.MasterDP]) Then
MsgBox "MyField has to be filled in!", vbOKOnly
Temp.MasterDP.SetFocus
End If


What is wrong with my codes, it keeps returing error 2465, can't find ....
Temp is a table with MasterDP as one of the fields

Please and Thank you ppl!
Sep 11 '07 #1
Share this Question
Share on Google+
1 Reply


JKing
Expert 100+
P: 1,206
If IsNull([Temp.MasterDP]) Then
MsgBox "MyField has to be filled in!", vbOKOnly
Temp.MasterDP.SetFocus
End If


What is wrong with my codes, it keeps returing error 2465, can't find ....
Temp is a table with MasterDP as one of the fields

Please and Thank you ppl!
Hi there,

I think what you want to do is to refer to the fields on the form that display the fields from the table rather then reference the table itself.

Try this:
Expand|Select|Wrap|Line Numbers
  1. If IsNull(Me.MasterDP) Then
  2. MsgBox "MyField has to be filled in!", vbOKOnly
  3. Me.MasterDP.SetFocus
  4. End If
  5.  
Now, I'm assuming MasterDP is the name of a field on your form.
Sep 11 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.