I use the following code to jump to an account by entering an account number. I just need to put a little MsgBox error in there saying there is no such account number when a bad account number is entered. It originally was a Combo Box and the error simply went in the NotInList Event, however, it is now a text box because there was to many records and no real reason to have a combo.
Right now it will just stay at the previous Account number after update and do nothing else. How do I trap this?
After_Update:
Me.RecordsetClone.FindFirst "[AccountNumber] = " & Me![txt_Jump]
Me.Bookmark = Me.RecordsetClone.Bookmark
Right now it will just stay at the previous Account number after update and do nothing else. How do I trap this?
After_Update:
Me.RecordsetClone.FindFirst "[AccountNumber] = " & Me![txt_Jump]
Me.Bookmark = Me.RecordsetClone.Bookmark