Listbox not updating combobox

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

Guest

I have a list box that displays a filtered set of records, what I would like
to do is have the user doublclick on a listbox entry and thus doing so it
sends a filtered responce to 2 comboboxes. The list box displays employees
from various contracting companies, when you doublclick the contracting
company should be displayed in the textbox portion of combobox number 1 and
the employee of the contracting company should be displayed in the textbox
portion of combobox number 2. i can get the contracting company to show up in
the listing portion of combobox number one, but not in the textbox. And in
combobox number 2 I get the listing of the employees for that contractor but
the employee I selected in the list box isn't highlighted in the textbox.

How might I go about making sure that these parameters are meet for the user?
 
Now, I'm fairly new to access programming... but if you ran a double click
event you could manually move from control to control. Because I think to
manipulate a combo box the combo box has to have focus... although I might be
wrong.
 
Cameron,

What is the purpose of the combo boxes if you already have a listbox that
allows you to select a user/company?

In the double click event of the listbox, you should be able to do something
like:

Private Sub yourListbox_DoubleClick()

'Since you did not indicate which fields were in which columns, the column
'indices below are arbitrary.
me.combo1.value = me.yourListbox.column(0)
me.combo2.value = me.yourListbox.column(1)

End sub

Dale
 
Actually, your right. I already have combo boxes that allow filtering.
However, even through I have those the Primary user refuses to use them to
locate their information but wanted a search box with a listbox to locate
employees of contractors. I told him that if he typed partial entries in the
employee combo box that it would filter his selection, but he didn't want to
click on the drop down arrow to have to see the list. he wanted to just
search for the person and then click once to have the program pull up the
employee safety particulars.

Thank you for your help.
 
Users, who needs them! ;-)

You go to all the trouble to make something user friendly, and they want to
do it the hard way!
 
Back
Top