Stopping Changes

3

3ddy

I have a form with a datasheet subform. What I am trying
to do is once the user enters a record in the subform,
lock that record so they cannot modify it anymore, be it
modifying a field or deleting a record. Any help would be
appreciated.
 
J

John Vinson

I have a form with a datasheet subform. What I am trying
to do is once the user enters a record in the subform,
lock that record so they cannot modify it anymore, be it
modifying a field or deleting a record. Any help would be
appreciated.

Be sure that the following properties are set on the form you're using
in the subform:

Allow Additions = True
Allow Edits = False
Allow Deletions = False

and make sure that they NEVER make ANY mistakes on the initial
entry... <g>
 

Ask a Question

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.

Ask a Question

Top