How can I customize a combo box in an input form?

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

Guest

I have a form that provides input to a Table. In that form there is a combo
box that is supposed to select which record the data is being input to. The
problem is I cant get to the next record by the list in the combo box. The
only way I can change records is by tabbing through all of the fields, then
when I get to the end the combo box automatically changes to display the next
record. How can I get the form to send the data to the record according to
the selected field in the combo box?
 
I have a form that provides input to a Table. In that form there is a combo
box that is supposed to select which record the data is being input to. The
problem is I cant get to the next record by the list in the combo box. The
only way I can change records is by tabbing through all of the fields, then
when I get to the end the combo box automatically changes to display the next
record. How can I get the form to send the data to the record according to
the selected field in the combo box?
Click to expand...

A Combo Box has two functions: it can be used to update data in a
table, or it can be used as a navigation tool. These two uses are
pretty much incompatible!

I'd suggest creating a new combo box on the form, using the Toolbox
Wizard. Take the option "use this combo to find a record". It will be
an *unbound* combo - its Control Source property will be blank; and
there will be some wizard-generated VBA code in its AfterUpdate event
to navigate to the selected record.

Note that you don't need to tab through all the fields to move between
records. Unless you've turned them off, there are navigation buttons
at the bottom left of the form; the > key will move to the next
record, < will move to the first, etc. PageDown and PageUp will do the
same.

John W. Vinson[MVP]
 
Back
Top