Listbox not selecting first value properly

[Help.Chris]

Hi all,

I have a list box that is required to have the first value autoselected when a combobox's contents are changed.
I have this working using "Me.ClerkList.Selected(1) = True" which works.

I have another listbox based on the selection in the first listbox. This is set to requery at the same time the combobox contents change, though after the selected comand. This is not updating due to the selection in the first listbox not changing properly. The box is highlighting the first row, but if i msgbox the value selected it never changes with the selected row unless i am clicking on the listbox itself.

How can i accomplish this, i need to be able to have the contents of the second listbox change at the same time as the first??? ie.

i change the contents of the combobox, this changes the contents of the first listbox and selects the first value, then the second listbox changes to show the records matching the id of the first listbox.

Thanks for any help!!!

chris

 

[Rich]

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=44193

 

[Help.Chris]

Post question is wrong place by mistake!

Sorry posted question in wrong place, which is why have re-posted in forms section!!!

Thanks for any help anyone can give me on this