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

Prevent Deletion of Keywords in a Combo Box Table

P: n/a
Although I have been able to prevent the deletion of keywords in a
separate Access 97 combo box table, the code that I'm using probably
requires updating because of the strange error messages that are
displayed after the message box is clicked.

Any assistance to clean up the code below and/or replace it with
something more consistent with the intended results will be
appreciated.

On Delete Event Procedure

If Keyword = "Display" Then
MsgBox "This Keyword cannot be deleted."
Cancel = True
End If
End Sub

I have received four different types of messages following the
clicking of okay on the message box, like: Method 'Do Menu Item' of
object 'IDoCmd' failed; the object doesn't contain the Automation
object tblIntro (this is a one check box field in an unrelated table
and even after deleting it and associated code, it made no
difference); database can't find the field "Forms" referred to in
your expression (don't have a field named Forms).
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.