Adding New Records To Table

[Juan4412]

I have a table that currently has data in it. I want to use a form to all users to add new records to the table. I do not want the user to be able to edit existing data, only add new data.



Is the best bet for this to manually create labels/textboxes and use vba to map the textboxes to variables and use an Insert statement in VBA to add the newly input user data?

Or how should I achieve this?

[Welshgasman]

Set Data Entry for the form to Yes.
To be on the safe side, set Allow Deletions/Edits to False.

[Juan4412]

Set Data Entry for the form to Yes.
To be on the safe side, set Allow Deletions/Edits to False.

Click the table then do form wizard and let it set things up that way?

If I remove record navigation will it always show an "empty" fields so data entry only? (not data already in the table)

[Welshgasman]

Try it.
I have never used Data Entry = Yes, so again, you would need to try out. As you get a new record each time, not much call for navigation I would have thought?