Null value to a variant - error

[Ed S.]

I am using a combo box to present a list of items in a form.

My intentions are to allow Blank input (not required entry), or data from the list. If data is not in list, default entry to blank or error message.

**************
I have tried using following events to replace data if null with a blank:

Private Sub ThisComBox77_BeforeUpdate(Cancel As Integer)
If IsNull(Me!FBTSC.Value) Then
Me![FBTSC.Value] = " "
End If
End Sub

Private Sub ThisComboBox_NotInList(NewData As String, Response As Integer)
If IsNull(Me!FBTSC.Value) Then
Me![FBTSC.Value] = " "
End If
End Sub
***********************

I continue to get tried to error " you tried to assign Null value to a variable that isn't a variant data type."

This data field comes from a linked query/table(AS400/DB2).

How do I handle null condition? (i am very new to MS Acess)

 

[Dugantrain]

One thing I notice off-hand is that you're using the .value property for your form objects. I seem to remember this being a difference between VBA and straight-cold VB. Take out all of those .value's so that you just have:

Me!FBTSC

and see if that gets you any closer.

 

[Dugantrain]

But I don't quite understand why you don't just set the Required property to False in the underlying table? Will that not accomplish everything that you're trying to do?