Default value in list box

[Help.Chris]

Hi everyone,

Thanks for any help in advance.

I have a list box which has a different row source depending on a condition selected in a option group. When changing the option group, the list box updates, but the form remains on the item selected in the previous selection, even if it does not exist in the current list.

Therefore, when changing rowsource in the listbox, i want the first item always to be selected. It there a way this can be done.

Just putting [listbox].[Itemdata](0) in the default value property does not work.

Thanks

 

[jwindon]

Docmd.RunCommand acCmdRefresh

May be in order.