View Full Version : Moving to first record of subform when requerying


Help.Chris
04-08-2002, 03:40 AM
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
04-08-2002, 04:56 AM
Again, two statements
DoCmd.GoToControl subform
DoCmd. GoToRecord
Use the builder to get the syntax correct

Help.Chris
04-08-2002, 06:09 AM
Thank you, that helped, and it is wotking now.

Chris