Users regularly try to delete the contents of a combo box by pressing the delete key when all they want to do is cancel the event or search for another record. They get the "you tried to assign the null value to a variable that is not a variant data type" system error message. Does anyone have a solution to this problem? A sensible message and a piece of undo code is probably what I need but I'm not sure. I've tried to by-pass the system message using Response = acDataErrContinue
and my own error message but that's not trapping the error. Any ideas?

Trap the error number (Err).

In the KeyDown event of the ProdID Combo box on your Form "sfrmOrderDetails" put this code:

If KeyCode = vbKeyDelete Then
MsgBox "You cannot delete this item."
SendKeys "{ESC}"
End If

HTH,
Jack

Dear Mr Cowley

What a wonderful person you are. It is working beautifully, as always.

DBL