create a form , user can add data only.

[scopes456]

Newbie here, Is there a way to create a form that anytime i open it , i enter the data, when i hit save. the fields in the form goes blank and the data is saved in the table. Also when i open the form again, and repeat this process , it just adds to the table and does not delete previous data. Sorry if my question seems confusing. Thank You for your help.

 

[John Big Booty]

The following code in the form's On Current event would do what you are after;

Me.[URL="http://office.microsoft.com/en-au/access-help/allowedits-property-HA001232718.aspx"]AllowEdits[/URL] = Me.[URL="http://office.microsoft.com/en-au/access-help/newrecord-property-HA001232762.aspx"]NewRecord[/URL]

Alternately have a look at the form's Data Entry property.

 

[scopes456]

thank you it worked

 

[scopes456]

I thought i had the problem solve, but i am stuck. i enter the code you provide, but anything i open the form i get an error for cannot find "me". i attached a picture of the sub form i want user to just add data and not delete. the form is label "Gse/In Service. My question is how, and where i go to enter the code. i believe that i entered it in the wrong place. thank you for your help. A little more info about the database, i make it split and i have created an .accde file.

 

[John Big Booty]

If you are dealing with a sub form you will need to use the correct syntax to refer to it.