Record Focus in a continuous form

[stephenk1973]

I have a continuous sub form that filters the data shown using the parent-child properties. When changing the parameters, the sub form updates but the focus remains on the same record number and the sub form displays half way down the page. If new data set has fewer rows the sub form will focus on the last record.

Is there a way to force the focus on to the first row? I do not want to use ‘Requery’ as this slows the application down.

Thanks

Stephen

 

[tinymind]

Try this in the subform after update event ...

Private Sub Form_AfterUpdate()
DoCmd.GoToRecord acDataForm, , acFirst
End Sub

Tiny

Perfection is Everything
If it worked first time we wont be here!

 

[stephenk1973]

When this is attached an object name is requested.

DoCmd.GoToRecord acDataForm, Forms.Parent.SubForm.Form, acFirst

After introducing the object name the form says the 'object does not support this propert or method'??? Funny thing is if you create a button to complete this in the sub form it works (without the object name). Any ideas?

Thanks

Stephen

 

[stephenk1973]

Have managed to get the effect i want with.....

Subform.Form.Recordset.MoveFirst

Thanks for all help and suggestions.

Stephen