You are, however, making a big mistake by allowing users to enter/edit
data directly into a table. Tables have no useable events and are
susceptible to data entry errors.
You should hide your tables and make the users use a form for all
entry/edits. No reason not to. If you wish the appearance of a table,
simply open the form in Datasheet view.
Opening the table "acEdit" simply opens the table for editing but I am able
to add records to the table. I believe I need to open a form in datasheet
view and set one of the properties to edit only (your last suggestion).
