Removing Focus from a List Box

[Aaron78]

Hi All,

I have a form with 3 list boxes. The user selects an option from each list box and depending on their selection a set of data appears in a subform. If the user then goes back to the first list box and makes a new selection, the next two list boxes still have their records highlighted from the last set of selections. What is the line of code that would remove the focus from the second and third list boxes if a value in the first list box was changed?

Any help would be greatly appreciated.

Best Regards,

Aaron

 

[Smart]

On enter of 1st listbox

me.listbox1.requery
me.listbox2 = 0
me.listbox3 = 0

on enter of 2nd listbox
me.listbox2.requery
me.listbox3 = 0

on enter of 3rd listbox
me.listbox3.requery

 

[Aaron78]

Thanks

Brilliant. Thank you. I love this forum. I would have been at that all day.