combo box/ list box

  • Thread starter Thread starter glm132
  • Start date Start date
G

glm132

I'm designing a database for work to track the agreements that each
program in our agency has with other agencies in our community. frmMain
is the data entry form that will be used to enter this data. It is
based on tblMain and has several fields, including:

lbxDivision: a list box that gets its values from tblDivision. User
selects one of our 5 agency divisions.

lbxProgram: a list box that is populated from tblProgram based on the
selection in lbxDivision

cboPartnerAgency: this is the field that will show the name of our
partner agency and also the field that I'm having problems with. The
data for this field is coming from tblPartnerAgency which consists of
an autonumber ID field and fldPartnerAgency. On the form, I started
with this field as a list box, because I want the user to be able to
see multiple Agencies at once. However, I want to allow the user to
enter agencies that are not on the list. Since list boxes don't allow
data entry, I switched this over to a combo box and used the
OnNotInList feature to allow the user to enter agencies that are not
currently in tblPartnerAgency. All of that works fine...

My question --- is it possible to have multiple rows of the combo box
showing at all times (with a scroll on the side) or do combo boxes only
appear as drop-down boxes??
 
Combo boxes can only be viewed as a dropdown. If you want to show
multiple rows, consider creating a form with a listbox on the left and
a textbox on the right. If you double-click the left pane, the value
will populate in the right pane. If you want to enter a new value not
in the left pane, enter it in the right.

It's probably more complex than that, but someone at my company
developed a tool that does this and it probably works exactly how
you're looking to make one work. I never looked at the code behind it
though.
 
Back
Top