Enabled = False

[Juan4412]

I have imported a spreadsheet with over 300 entries of orders that have been placed, I want the "Order" portion to be locked once I import it. I have the VB code set in place to when a new entry is logged in the database once the "Add Record" is hit it locks, but how do I lock the entries that were imported from my spreadsheet?



I have a feeling a query could do this, but I am new to access and not sure how I would go about doing it.

Any takers?

[ajetrumpet]

"locks it" means exactly what's in the title of the thread, I'm guessing??

if so, what you do is set "enabled = false" after checking "me.newrecord" on the CURRENT() event of the form.

[Juan4412]

I only want it to lock, or gray out the fields that have been populated. There are a few fields on the form, that will be populated as new information comes through, like a memo field and that type of thing. I only want it to lock the data that the 1st contact person would enter. But since I imported I don't know how to set it up to lock just those entries.