Avatar of kwarden13
kwarden13 asked on

Access Can I unlock only 1 field from a sub form?

Hi!

I only want to unlock 1 field from a sub form. However the subform is linked to a query. I just want the people to be able to only edit one of the fields.

Thanks
Microsoft Access

Avatar of undefined
Last Comment
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

8/22/2022 - Mon
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

For all of the other fields, set the Control's Locked Property to Yes.

mx
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

see attached image
Capture1.gif
ASKER
kwarden13

There are no individual cells like that on my subform. there is just a box that displays the query results. I can lock/unlock that, but I need individual fields locked and/or unocked.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

"There are no individual cells like that on my subform."
Not following ...?  What fields are you referring to then ?

Do you have a screen shot ?

mx
ASKER
kwarden13

It is a query so in the design mode it just shows a big box. Not individual boxes, so I can only lock/unlock all the cells.
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Humm .... I kind of need to see this in a screen shot.  You say a 'query' ... in a box?  Not visualizing that, sorry.

mx
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
kwarden13

This is what it looks like  screeenshot.doc
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

What I'm seeing in the screen shot looks like a datasheet view form.  And you say there are no cells, but I see Date_Added, Date Modified ... and so on.  So sorry, I'm still confused.

mx
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

In fact, looking at your other screen shot from the other Q, this is a datasheet subform, on a tab control on a main form.

mx
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER
kwarden13

No its not. Its a main form with a subform that has 4 tab controls.

You can't change the individual fields.

See the Screenshot attached  of the form in design view.  screeenshot.doc
ASKER CERTIFIED SOLUTION
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
kwarden13

Took a while to get a response
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

"Took a while to get a response"

?  Not following ...

mx
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
kwarden13

Not to be ungrateful for your answer, but the website made me out a comment on why I gave you a B instead of an A.
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

"why I gave you a B instead of an A."
And that is because ?

mx