Data Type Mismatch Error

[adam]

Hi anyone,

I've set userform initilize event as follows

Code: Select all

Private Sub UserForm_Initialize()
    cboUserName.List = Array("Adam", "Smith")

and to get the user name usding a sql query from access database, im using this line.

Code: Select all

Me.cboUserName.Value = rst![User Name]

But Im geting error message "datatype mismatch in there's no value in the data row of Access table. It works fine if there's data.
is there a way I could avoid this error message if there's no value in column?

Any help would be kindly appreciated.

[HansV]

I'm not sure I understand, perhaps

Code: Select all

    If Not IsNull(rst![User Name]) Then
         Me.cboUserName.Value = rst![User Name]
    End If

[adam]

It worked. Thanks for the help.