My Users -- Submit button

[eepok]

Hey all,

I'm in a pickle and hopefully you guys could help me out. My users are old and scared. They require things made in a familiar fashion which slows people in the know, but it's what makes them work well.

My most recent request from them requires me to make a "Submit" button for one of the forms that way they "know" the data is in the table. However, I know of no way to hold data cached until a button is pressed.

Is there a way to do such a thing? Cache data until a button is pressed? To the best of my very limited knowledge, data entry takes effect immediately.

 

[boblarson]

Actually, the data isn't really stored until you move to another record. So, you can have a button on the form that just uses:

If Me.Dirty Then Me.Dirty = False

or

DoCmd.RunCommand acCmdSaveRecord

to save the record before moving to another record.

 

[eepok]

Actually, the data isn't really stored until you move to another record. So, you can have a button on the form that just uses:

If Me.Dirty Then Me.Dirty = False

or

DoCmd.RunCommand acCmdSaveRecord

to save the record before moving to another record.

First, thank you for correcting me.
Second, thank you for the tip!

 

[eepok]

Well, heck, Bob. It won't allow me to add to your rep. I guess I'll have to add you to my "Buy a beer if I ever meet him" list.

 

[boblarson]

Well, heck, Bob. It won't allow me to add to your rep. I guess I'll have to add you to my "Buy a beer if I ever meet him" list.

No problem - you must have given me rep earlier so you have to give it to another 10-15 people before you can do it to the same person again. I'm not sure exactly how many it is that you have to do but I think it's about 10.

And thanks for the thought though!