Ctrl-F records on locked field

Hi All,

I have a field on an access database, JobNo. I have locked this field in the form to prevent it being changed, however, I want users to be able to search for records with this field. How do I achieve this as I cant once it is locked.
Who is Participating?
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
Do you mean Disabled ... or Locked ?  Locked allows your to click into the field and search, sort, etc.

Be sure you don't have Enabled set to No ... instead Enabled = Yes, Locked = Yes.

thorpey83Author Commented:
Easy one... Cheers
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.