Enter once into a field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All,

I have a form setup with 2 subforms within it. There are a few fields in my
main form that I would like to be able to set so that the user can only add
into these fields and once the user has added the information it will become
locked and can't be edited or deleted. All the other fields apart from these
few I would still like to be able to edit as required.

Is there a property either on the form or table that will only allow
additions for particular fields?

I have found the Allow Additions, Allow Edits and Allow Deletes in the
properties but it seems to be for the whole form not just for one field.

Any help will be appreciated.

Thanks in advance.
 
If you trying to lock only few fields and not all of them, then you need to
specify which field you want to lock

Me.[FieldName].locked = True
 

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

Similar Threads

Protect data once entered into field 3
Access MS access forms list box problems 1
Form Suddenly Became Non-Editable? 1
Copy record in one form into a new pop-up form 0
Locking specific data in a continous form 2
Protect data entered in fields in form 2
Remove permissions on both form and table 4
Locking Fields 3

Back
Top