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?