new record should be saved only when a button clicked

[Rajashekar_S]

Hello all

I have a data entry form... with many fields..... the question is ...

Is there any way that i control the update of new record with a button...

i mean while i am entering the data in the form.. the form should not auto updated the new record till i click a button, only then the data should get updated.... also i place a button called "cancel" if i need to cancel the addtion of new record.

 

[namliam]

You would have to make the form unbound.... OR keep this one bound... then also "locked" so the user cannot edit it...

They then have to click "edit" which opens up either the form or a second form. In both cases again unbound...

Have a search for unbound forms and see how far you can get. Ask any direct questions again here.

 

[valheru]

Hi

Yes, unbound forms are the way to go to achieve this. I use unbound forms which I feel gives me greater control of how to control and manipulate the data.

I then use SQL statements which are run when the user clicks the buttons.

If needed, I could whip up a quick example which shows you how I do this.

 

[MStef]

You can do it without a command button.
Look at "DemoNewRecA2000.mdb".
Open form and try.

 

[pauld118]

Would you please give the example. I'm trying to do the exact same thing. Thanks

Hi

Yes, unbound forms are the way to go to achieve this. I use unbound forms which I feel gives me greater control of how to control and manipulate the data.

I then use SQL statements which are run when the user clicks the buttons.

If needed, I could whip up a quick example which shows you how I do this.