How to Synchronize Combo Box with Text Box After Going to Next Rec

  • Thread starter Thread starter VC
  • Start date Start date
V

VC

I have a combo box called [Title Pick] that I use to display catalog titles
to get to the record for that title. I also have a text box, called Title,
that shows the title I just selected in the combo box.

In addition, I have several navigation buttons used to go to the next
record, previous record, etc.

After I navigate to a different record using one of these buttons, the text
box, Title, has the correct value -- but the Combo Box, [Title Pick], still
shows the value from the last time that combo box was used. How do I now get
the combo box to show the correct title for that record?
 
You can set the control source of the combo box to the appropriate field in
the forms recordset. Since you did not post any information about the query
or table that the form is based on, I cannot say what that field would be. It
could be an ID field or the field with the Title.

Is there a particular reason why you want the combo box to change? Based on
your scenario, the combo box is just a way of navigatiing the records, just
like the buttons. I don't see where you would gain any real benefit from
having it update when you used the buttons, IMO.

Chris
 
Back
Top