"Gray out" subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tracey - 25 Oct 2005 20:18 GMT

Using MS 2003, I have a form with a subform. Based on checking a field on the
master form, I would like the subform to become inaccessible (ie. grayed
out), but I don't want the subform to become invisible. Is there a way to
make the entire subform inaccessible, but visible without making each
separate field in the subform inaccessible individually?

Reply to this Message

Ofer - 25 Oct 2005 21:38 GMT

Try
Me.[SubFromControlName].Enabled = False

Or
Me.[SubFromControlName].Locked = True

Signature

If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

> Using MS 2003, I have a form with a subform. Based on checking a field on the
> master form, I would like the subform to become inaccessible (ie. grayed
> out), but I don't want the subform to become invisible. Is there a way to
> make the entire subform inaccessible, but visible without making each
> separate field in the subform inaccessible individually?

Reply to this Message