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
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