sample VB code for combo boxes

[Trekk]

I have 2 fields both are combo boxes. I need some example code that if one combo box is null no data in it then it will set the other combo box to a default value.

One combo box is populated with usernames and the other is populated with status codes like active unassigned, etc.

If there is not a name in the user combo box then I want the status to read unassigned.

 

[JoeAtWork]

Perhaps:

If Nz(cboUserName,"") = "" Then
  cboStatus = "Unassigned"
Else
  cboStatus = "Assigned"
End If

 

[Trekk]

I tried that but I cant seem to get it to work

Here is my code

Private Sub Form_Load()
If Me.CareCoordinators.Value = "" Then
Status.Value = "Unassigned"
Else
Status.Value = "Assigned"
End If
End Sub

I tried pasting your code and just changing the names of the objects they were referencing but it was throwing up an error about type mismatch