Forum Discussion
Unlock locked fields in MS Access
Hi Experts,
I'm new to MS access. I've a file which I need to use as an input for my development work.
I would like to know how I can edit the form in the file to update the required values.
Please find the details below.
When I open the file, the Main form shows the data as in the below screenshot.
The shortage Data and Group Branch fields seems to be locked for editing. I would like to know how I can change this hardcoded value. My requirement is to change it to a different file path in both fields.
As I mentioned, I'm a beginner in MS access. Please let me know if you need further information to resolve this matter.
7 Replies
- try to bring your form in Design view and click on one of the textbox.
on Property Sheet->Data, set to:
Enabled = Yes
Locked = No- Hi Arnel, could you please help me with my follow-up query?
- show the SQL statement of your query.
Hi arnel_gp,
Thank you so much. It helped.
However after changing the filepath, while I try to get data, it is throwing a strange error.
The filepath in the error pop-up is preceded with a documents folder path to the filepath I have mentioned in the fields.
Is there a default database path which I need to correct to resolve this issue?
