combo boxes and navigation bar

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created a maintenance form for a Access 2003 table. The form has numerous
text boxes bound to various fields in the table. The combo box I added (via
wizard) to move to a record based on the combo box selection, does not update
if I move to another record using the navigation bar. It also reverts to a
blank display if I go from design mode back to running the form. The combo
box is unbound and its "row source type" is table/query and "row source" is a
sql statement. How can I get the combo box to update in those cases? Thanks!
 
Rocarr,

I would have thought the way this is functioning at present was
appropriate. It can sometimes be confusing if you try to use the same
control for more than one purpose, i.e. in this case navigation and data
display. Whatever is the data which the unbound combobox would show is
also presumably included in the recordsource of the form, and can
therefore be shown via a bound control on the form. Still, if that's
what you really want, it is probably fairly easy to do, by putting code
on the Current event of the form, the equivalent of this...
Me.NameOfYourCombo = Me.NameOfRelevantField
 
Back
Top