Design View or Form View?

Form View

That's normal behaviour. The record is automatically saved.

Is there a feature that can be turn to ask if you want to save the record instead of just saving automatically.

Not really. Access isn't like Word or Excel where you have to save your changes manually when you're done editing. Data is saved live as you edit it. I suppose you could rig something up with a little VBA code and some settings to emulate that behavior, but why would you want to?

I had another student ask me something similar a while back... he didn't want people accidentally editing records. What I suggested was to set AllowEdits to NO by default and make them click a button to turn EDIT MODE on. Then when they were done, they could either click SAVE or CANCEL. One would close the form and save changes. The other would issue an UNDO command and cancel changes. I added this to my list for a video, but haven't gotten to it yet.

Does that sound like what you're looking for? It will involve a little VBA, but not much.

Yes exactly. my concern is that if the user create a record with the wrong information and it get saved automatically

OK. Give me a couple days. I'll put a TechHelp video together.

thank you.

Here you go Anthony: Edit Mode. Members can view it now. Available to the public tomorrow morning.