Null Value

[CC]

I'm using Access 2003, and I have a field on a subform that shows up as a
combo box because I have a relationship defined on that field to another
table. Sometimes a user selects a value in the field, then decides that
nothing should have been entered and wants to abort entering the record. The
following error displays: "You tried to assign the Null value to a variable
that is not a Variant data type."

I've tried the Undo method, but get the same result. Any suggestions?

 

[KARL DEWEY]

and wants to abort entering the record.
Why not just delete the record?

Or is it that they want the field to be empty but keep the record? Then
why not add a Null record in the combo box source table that can be selected.
You may need to add a second field to that table so as to add the null
record.

 

[CC]

I would love to delete the record. Can you tell me how? If the focus tries
to leave the field, I get the error message. I can't click any other control

 

[KARL DEWEY]

Select allowable entry from the combo and then delete the record by clicking