Combo Box and record selector

[Guest]

I have a combo box set up on my form that is used to select specific item
numbers. The form then shows all the information for that Item number. The
combo box works perfectly except when someone clicks on the "next" or
"previous" record selection buttons on the bottom of the form. When these
buttons are clicked the item number in the combo box does not change. All of
the other information does however change to the next record. How can i get
the combo box value to also change when the record selectors are used?

 

[satty via AccessMonster.com]

is the combo box property - allowEdits set to YES?

 

[Guest]

Your combo is obviously an unbound control. Unbound controls know nothing of
the form's record source. If you want it to stay in sync with the data, you
can use the form's Current event provided there is a text box bound to the
field that matches the row source of the combo.

If Me.NewRecord Then
Me.MyCombo = Null
Else
Me.MyCombo = Me.txtBoundTextBox
End If