Listbox selection question

[Guest]

Hi. I have two ListBoxes on my Form. Each listboxes row source types are
value lists. The form opens up with 1st listbox enabled, and 2nd listbox not
enabled. 2nd listbox only enables when user chooses something from 1st
listbox. What I am trying to achieve is that I want to be able to select a
choice from the 1st listbox, and that will automatically select the related
value from the 2nd listbox, other values in the 2nd listbox will remain
inactive. Is that possible?

Here is the example: List1 List2
-------- -----------
App1 Print-App1
App2 Print-App2
App3 Print-App3

As soon as I select App1 from List1, Print-App1 from List2 should
automatically be selected. Print-App2, and Print-App3 will remain inactive,
and so on.

Thanks in advance for the help. I really need it done today to meet the
deadline.
I appreciate it very much.

 

[Guest]

This doesn't make a lot of sense. If you have a 1-to-1 relationship between
the two listboxes, then you really onely need one list. Furthermore, you
cannot enable/disable selected items in a listbox unless you change the query
for the RowSource of the second list.

Can you describe "what" you are trying to accomplish, rather than "how" you
think you should accomplish it? What is it that you want your user to do to
with the second listbox?

Dale

 

[Guest]

Thanks moch for the reply. The user selects an item from the 2nd listbox,
and press a button, which will install a printer. And that part is working
with no problem.