i have a form that deletes a record in a table. The user chooses the relevant record from a combo box, and then click a button that says delete record, once this process is done and the user returns back to the combo box where the record has been a deleted there is #deleted listed in the combo box, but if a user by mistake clicks this there is an horrible error message, what can i do to avoid this, what VBA code could i put in the after update method? please help!
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.