How do I Lock a field in a sub-form

  • Thread starter Thread starter pat c
  • Start date Start date
P

pat c

I have a customer info input form and link to a subform. However, I would
like to lock a particular field in this subform and leave the rest of the
fileds in this subform unlock.
Anyone can help? Thanks a lot.

pat c
 
I have a customer info input form and link to a subform.  However, I would
like to lock a particular field in this subform and leave the rest of the
fileds in this subform unlock.  
Anyone can help?   Thanks a lot.

pat c
Click to expand...

locked as in design_mode -> Properties of the form -> Data -> set
Locked to Yes?
 
If you want to lock a control in a subform from the parent form:

Me.SubFormControlName.Form.ControlName.Locked = True

SubFormControlName is the name of the subform control on the main form, not
the name of the form being used as the subform.
 
Pat,
You don't say "when" you want to Lock the record... AfterUpdate perhaps.
Or, are your saying you want the field in one subform record Locked, but
that same field in other subform records editable?

Amswering your question just as you stated it... make the field...
Enabled = No and
Locked = Yes.
or just...
Locked = Yes
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Back
Top