Unselect list boxes

[tezread]

I have eight list boxes on a form. When you click on an item in a list the form populates with corresponding data.
I want the list box item to 'unselect' if I click from one list box to another
Here is what I have tried

Private Sub ListBoxName_LostFocus()
Me.OtherListBoxName = Null

I have tried this in GotFocus andf Lost Focus but nothing happens

Any ideas?

 

[vbaInet]

If I remember correctly, there are two ways of deselecting an item and this depends on the MultiSelect property you are using.

 

[tezread]

I don't want to have users select multiple items in a list box. Only a single item.

 

[vbaInet]

That statement indirectly meant, what is the Multiselect property of the listbox set to?

 

[tezread]

That statement indirectly meant, what is the Multiselect property of the listbox set to?

My bad

Multi select is set to none

 

[tezread]

i have somethung crude but it works

me.ListBoxname = Is Null

in the got focus property

 

[vbaInet]

Your initial code should work. Is it bound?

 

[tezread]

Your initial code should work. Is it bound?

initial code does work my friend. all sorted now

have problems with median average reports outputtting incorrect results though! see link

 

[vbaInet]

Good to hear