Saving the record 2

[nickjar2]

Just curious about this one.

Say I have a form. I am at a record and I change the record and then need to open another form based on the amended record. Until u move of this amended rec the changes are not posted, so i usually use something on the lines of moving to the next record and moving back. I always think this looks really unproffesional.

ie
docmd.movemnext
docmd,moveprev
docmd.openform

Is there an alternative that won't make me cringe every time I lok at the code? I don't think docmd.saverecord works (if the command even exists)

Cheers,

Nick

 

[jebry]

Hi Nick!

You can use DoCmd.RunCommand acCmdSaveRecord or you can use the with command:

With DoCmd
.MoveNext
.MovePrevious
.OpenForm
End With

hth
Jeff Bridgham