Save and go to new

[jbphoenix]

How do I code a cmdbtn to save the current record and then go to a new blank form?

The form opens with all fields being blank except the field for today's date and order_time, which is fine. The user fills out the form and then I would like them to click a btn that will save the record and then take them back to a blank form so they may enter another order.

Thanks for any help.

 

[rainman89]

create a button and put this in its onclick

    DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
    DoCmd.GoToRecord , , acNewRec

 

[boblarson]

create a button and put this in its onclick

    DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
    DoCmd.GoToRecord , , acNewRec

No, no, no, no! Ray - did I get through on that one.

Don't use DoMenuItem code. It can cause major trouble between versions.

Use Docmd.RunCommand acCmdSaveRecord instead.

Stay away from DoMenuItem code as it has been deprecated by Microsoft and is only in there as an aid to be backwards compatible. The correct way is to use the DoCmd.RunCommand acCmdxxx commands as they will do almost everything that the menu has.

 

[rainman89]

SHITAKI!!!!!!!!

all i did was use the button wizard and copy the code in that.
my bad

Glad you are here to clean up my mistakes

 

[boblarson]

Microsoft is horrible about that. They use outdated code in their wizards, so it makes it LOOK like it's okay. It's one of my pet peeves about them.

 

[rainman89]

Like ive seen many others say
i know enough to be dangerous and thats all

believe me... i have MANY MANY Peeves about microsoft.

did u get my message about the embedded pic?

 

[boblarson]

did u get my message about the embedded pic?

I don't think so.