Moving to first record of subform when requerying

[Help.Chris]

Hi,

I am stuck on this problem, i have a subform called "List Of All Agents", which is contained in a main form called "Agent Details".

I have a option group which changed the content of the subform, but when the selection is changed, the selected item in the subform does not return to the first item.

I have tried using gotorecord on the main form, but it can not find the subform. Does anyone know how to accomplish this. I do not mind adding code to the main form or the subform. Please also advise where to add the code.

Thanks for any help.

Chris

 

[Rich]

Again, two statements
DoCmd.GoToControl subform
DoCmd. GoToRecord
Use the builder to get the syntax correct

 

[Help.Chris]

Thank you, that helped, and it is wotking now.

Chris