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).
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
