Gregory Peck
New member
- Local time
- Today, 17:38
- Joined
- Jul 17, 2019
- Messages
- 7
Hello. I am not an access expert but I have been able to make a nice little access form that shows our products details, prices, sizes etc. I had it set that all the prices and other important data was locked so that no one could accidentally change the data. That worked great but if you wanted to make changes you had to go into the table and edit there which is a pain. So I found some code on google which sets Me.AllowEdits = false until I click an edit button then it allows edits on the whole record. This is great BUT now it has locked my search field as well so now I can not search unless I click edit which opens the whole record to editing thus defeating the whole reason for locking things.
So is there a way to override the Me.AllowEdits = false for one text box? Or a better way to lock all the record except the search field and be able to click a button to allow editing the record.
Thank you in advance for any help.
So is there a way to override the Me.AllowEdits = false for one text box? Or a better way to lock all the record except the search field and be able to click a button to allow editing the record.
Thank you in advance for any help.