Make highlight in listbox disappear (A2K (SR1))

Topic

New Reply

I have 2 single-pick listboxes in a form, each one opening a report. If I picked one option from listbox 1, and then move to listbox 2, how would I make the highlight in the first listbox disappear so that only the choice in listbox 2 is highlited? Thanks in anticipation.

Reply | Quote

Replies

Set value of 1st listbox to null. Ex:

Me.Listbox1 = Null

HTH

Reply | Quote

Thanks, David. It works.

Reply | Quote

Glad it worked but who’s David??

Reply | Quote

Sorry, MarkD, neither do I know who is David:) I got mixed up along the way. My sincere apology and thanks for your help.

Reply | Quote

Are you going to use the value selected in the first listbox for anything? If you are, then it would not be a good idea to unselect it.

Reply | Quote

No, Charlotte, the items in the two listboxes are independent of each other, though they are under the same broad category. DavidD’s advice worked very well for me. Thanks.

Reply | Quote