save last record in table through a form

[ajetrumpet]

all,

I have a form where I want to run the save record command behind a button. the problem is that the command only works if the button is in the record areas of the form (e.g. - detail section). the table will have 5 records in it when I want to save the last record.

question - how would I save that particular record (the last one) from the button if it is located in the form's footer?

[ajetrumpet]

I have figured out a workaround:

   DoCmd.GoToRecord acDataForm, Me.Name, acLast
   DoCmd.RunCommand (acCmdSaveRecord)

if anyone has something better that wouldn't cause flickering, I would like to know. thanks!

[dynamictiger]

What happens if you use Docmd.GoNextRecord?

[ajetrumpet]

What happens if you use Docmd.GoNextRecord?

interesting...but I'm not going to test it becauase using ACLAST does the job for now. nextRec would not improve the situation.