Form Entry Cancel

[cpaige]

Hi Everyone,
I want to make a form in Access using bound controls that would have save and cancel buttons. It seems that soon as an entry is made it is inserted into the database. I want to be able to press cancel and remove this new record. Does anyone know how to do this

Thanks,

Clayton T. Paige
claytonpaige@yahoo.ca

Programmer Extraordinaire

========================================================

"Who is General Failure? and Why is he reading my disk drive?"

 

[KenReay]

Hi

The changes are saved when you move off the record or close the form

disable any navigation or form close buttons, when you allow editing, after you save or undo, enable tehr navigation and form close buttons

code to undo and save is:

In the onclick event of your save button

If me.Dirty Then
docmd.runcommand acCmdUndo
End if

In the onclick event of your save button

If Me.Dirty
docmd.runcommand acCmdSaveRecord
End if

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[cpaige]

Thanks!

That's exactly what I needed.

Clayton T. Paige
claytonpaige@yahoo.ca

Programmer Extraordinaire

========================================================

"Who is General Failure? and Why is he reading my disk drive?"

 

[GTLoco99]

You will need to write a macro or some VBA for your delete button. When the user clicks it, it will fire off a DELETE Query that will remove the record.

Bellow is an example of how this may look in VBA.

SQLstr = "DELETE Attendies.*
FROM Attendies
WHERE (((Attendies.ID_Number)= " & Me.ID_Number & &quot);

The statement (" & Me.ID_Number & &quot is the field on your form that has the Index key in it. The query will delete all the values of the fields in your query when the index number = the value on the form

Hope this helps

GTLoco

 

[GTLoco99]

Quote
________________________________

"The changes are saved when you move off the record or close the form"
__________________________________

This isn't always true. If you form is a dynaset form (default for forms in access) then as soon as you start typing in any field on the form, a record is created on the table. If your form is snapshot, the it will only be saved if you use the save record function.