Adding Records to a Table From Form Question

[McArthurGDM]

Hi,

I would like the ability to have a form linked to a table and to be able to Add Records to that table from the form.

I want the user to have the ability to only Add - not edit or delete.

I realize that this can be accomplished by going to the Data section of form properties and specifying only allowing additions.

However, this causes a problem because when a user goes in to fill out the form and the clicks away from a cell and then tries to go back and edit it - they can not, which is frustrating.

I would like to have the user input/edit all the cells on the form that they desire and then have a button that will add all those records officially to the back-end table.

How do you accomplish this?

[ssanfu]

One method is to use an unbound form. You would be responsible to write the VBA code to insert (append) the data to the table; you would have to the validation, error handling, etc. Loads more work, but you have total control over what and when the data is added to the table.