moving to first record on subform

[Help.Chris]

Hi,

I have a subform whose contents are changed based on an option group.

When i change the selection, I have the subform being requeried.

When this is done, if in the previous selection, the second item was selected, the second item remains selected with the new contents.

I need the selection to move back to the first.

I have tried gotorecord on the option group, but i can not get this to work.

My master form is called [Agent Details] and the subform is called [List Of All Agents].

The master form is not bound to the subform.

Does anyone now how to achieve this. Thanks for any help.

Chris

 

[Rich]

Try Me.Refresh instead of Requery

 

[Help.Chris]

I have tried this, as the event is on the option group, i have to use [Forms]![Agent Details]![List Of All Agents].Refresh.

This does not work, as the method is not supported.

Please help, i have been working on this for ages.

Cheers.

Chris