Displaying Just entered Record

[hascons]

Hello,

I am working on an estimating database. I have a form with 3 separate subforms. There are times when I need to price the same Project for several different customers.

I created a Subroutine that copies the current record as well as the Subrecords for the corresponding Bid Number through a command button click. This all works well.

My problem is i copy from the record I'm displaying, I would like to display the record I Just Inserted as the current record after my subroutine runs. I can't requery the form because it just brings me to the first record. I tried to do a DoCmd.GoToRecord , , acLast, But this brings me to the record before the one I just entered.

How do I get to the Last Record I Just Copied and display this record so I Can Change the Customer, Date etc..

 

[SpentGeezer]

Greetings,

Try throwing something like this in (to save the record )

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

then use the DoCmd.GoToRecord , , acLast command.

 

[hascons]

SpentGezer,

I was able to get the following to work:

Me.Requery
DoCmd.GoToRecord , , acLast

Thanks for your input.