Adding Record in the bound Form using Command button

I have Two forms one is switchboardFrm and MembershipFrm

I have a Command button "Add New Record" in the switchboardform that basically opens second form called MembershipFrm

When I insert the record in the second form without allowing me to save the record it get saved and update my table.



I don't understand the use of the command button for saving a record when everytime I change anything on a field in a bound form, it is instantly updated in the
database which is what I DO NOT want. How can I make it so the user has to click on the save button to save the record without the fields automatically
getting updated in the database while using the bound form....

Thank you
Bijaya

I think that for what you want to do, you must use an unbound form and then use script to save the information to your tables. Access will automatically update tables when you use bound forms. Why is it important to save with a command button. Why not have the record stored(saved) automatically.

Alan

I really don't have problem saving Record automatically, but I have problem updating record that I don't want to.

Let me explain in detail. User wants to update record, but by mistake he/she opens different record in the MimbershipFORM and started changing the fields. After changing only he realizes that he is modifying different record at that moment he does not want to update that record rather wants to cancel . How can I accomplice this using Bound form?

Thanks
Bijaya

I have problem updating record that I don't want to.

Let me explain in detail.
I wants to update record, but by mistake I open different record in the MimbershipFORM and started changing the fields. After changing only I realize that I am modifying different record. So I dont want to update that record rather want to cancel .
How can I accomplice this using Bound form? Is it possible?

Thanks
Bijaya

Using a bound form, Access automatically updates any changes made. You would need to have an unbound form and then use a command button to fire the save to the table. It is important to pay attention to what you are modifying when using access.

Alan

Thank you for the response.

Did you ever figure out how to do this? I'm trying to do the same thing.

I did the same thing that Alan said

"Using a bound form, Access automatically updates any changes made. You would need to have an unbound form and then use a command button to fire the save to the table. It is important to pay attention to what you are modifying when using access".


I didn't use the unbound what he suggested but I started saying user to pay attention to what you are modifying when using access.

Bijaya