Tracking down the source of error 'The value yo entered isn't valid for this field' (1 Viewer)

[Freeflow]

I've obviously changed something in the background as I'm getting the following error "The value you entered isn't valid for this field" (80020009).

This is the code

Private Sub Form_Current()
' The assignments below keeps the unbound combo boxes cmbFamily and cmbNameGeneric in line with
' the selected record when using the form navigation buttons

Me.cmbFamily = Me.Recordset!Family
Me.cmbNameGeneric = Me.Recordset!NameGeneric

End Sub

The error is triggered by the Me.cmbNameGenric line.

The error only occurs when I type into or select using the cmbFamily combo box.

Navigating records using the navigation tools at the bottom of the screen don't trigger the error.


The content of

Me.cmbNameGeneric
Me.Recordset!NameGeneric

Appear as strings when in debug mode.

I'm flummoxed.

Thanks in advance

 

[gemma-the-husky]

I would add a breakpoint and step through the code.

or add a message box to see what value you have?

is cmbnamegeneric inadvertently typed as a "date" perhaps?