Listbox selection question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tasmania - 30 May 2007 19:25 GMT

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.

Signature

thadi

Reply to this Message

Dale Fye - 30 May 2007 20:44 GMT

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

Signature

Email address is not valid.
Please reply to newsgroup only.

> 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
[quoted text clipped - 17 lines]
> deadline.
> I appreciate it very much.

Reply to this Message

Tasmania - 30 May 2007 20:55 GMT

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.

Signature

thadi

> 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
[quoted text clipped - 28 lines]
> > deadline.
> > I appreciate it very much.

Reply to this Message