Lock imported data in access table

I have an access database in which I import data from one of our customers and then our employees enter additional data to add to the data from the customer on forms. Is there a way to lock the data that is imported from our customer in the table and still allow our employees to enter new data on the forms? Just a note the forms within our database do contain continuous forms in which will contain data from the vender and also need to allow the user to enter in the fields also.

Thank you
MRG_ALAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
add a YesNo field (Lock) to your table
for all imported records update the Lock field to True
include the Lock field to the Record source of the form

in the current event of the form set the locked property of the controls

private sub form_current()

me.text0.locked=me!lock
me.text1.locked=me!lock


end sub
0
 
als315Commented:
Are you filling additional fields (empty) to imported records or you like to add new records?
0
 
MRG_ALAuthor Commented:
That worked thank you!!! : )
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.