Save and form binding to a table or query

[DevAccess]

Hello

I have form bound to query and so whenever there is a new record being created using form, and if I change the value of any of the field or I try to enter teh value into the field it automatically saves the record.

What I want is until and unless if records is not being saved using save button on the form it should not save the record.

I would like to have SAVE and CANCEL buttons which would do save and cancel the action respectively.


Thanks
MANN

 

[Ranman256]

the standard method of bound record is to ALWAYS save the record.
if you do NOT want this,
create a form that us UNBOUND to a table/query.
the Save button will then run an append query (if new, no key)
or
an update query is the record existed. (existing key)