Combo Box and record selector

T

Ted W.

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

Klatuu

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clearing combo boxes and a text box 2
Dynamic Naming of Form Button 3
Creating a Search using a combo box and then creating a report. 4
Combo box 0
combo box value does not change when record selector is used 4
Copy previous record into form field 0
Identifying and changing Avery template numbers 0
First Subform record gets modified when closing form 3

Top