go to last record on form 1

[jazminecat]

I have a form for adding a new record. when the user clicks Save, it asks if they want to add another. If not, it saves the record and opens the BidScheduleForm. I'd like to go to the last record on the BidScheduleForm, which should be the new one just added.

I've played with this to no avail in the Onclick event of the Save button:

DoCmd.OpenForm "BidScheduleForm"
BidScheduleForm.Recordset.MoveLast

It gives me an "Object Required" error, and just an ok button. It does open the right form, just not at the last record like I wanted. Any thoughts?

Thanks!

 

[PHV]

And this ?
Forms!BidScheduleForm.Recordset.MoveLast

Or this ?
DoCmd.GoToRecord acDataForm, "BidScheduleForm", acLast

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

 

[jazminecat]

ah, the second one seems to be working. thank you again PHV!