Combo Boxes

[Steve Dunn]

Is there an easy way to update a combo box to reflect the
record that the user moves to when they use the form's
navigation buttons?

I have a companies table. 2 of the fields are companyName
and companyNumber. I have a combo box (cmbCompany)that
lists the company names in alpha order. When the user
selects the company name from the dropdown list, the
record for that company is displayed. I also want to give
the user the capability to move to the next / previous
record. When they use the form to go to a new record, how
do I update the combo box to display the company name of
the current record? All I programatically access the
navigation buttons?


thanks

 

[Ken Snell]

Use the OnCurrent event of the form to write the "new" record's company name
into the combo box as its value.