Positioning in Subform 1

[apestaart]

Going to a control in a subform I have already found out.
But how to go to the last record of that subform to change data I can't find.
Who can help me.

regards Apestaart

 

[Remou]

You can use:
[tt] DoCmd.GoToRecord , , acNewRec[/tt]

 

[PHV]

Forms![mainform name]![subform control name].Form.Recordset.MoveLast

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[apestaart]

Thank You PHV. That works. Where can I find more abaut those syntaxes?

Sorry Remou, I want to go to the last record not to a new one. It in not possible to use DoCmd.GoToRecord because I can't name the subform as a form.

Regards ,
Apestaart