Locking subforms? I should know this but....

  • Thread starter Thread starter Patrick Graham
  • Start date Start date
P

Patrick Graham

I have a main form and a bunch of sub forms.

I want to let some people use the forms I created but for
now I want them only able to view records not change them.

Is there an easy way (bit of code) to add to the main
form that will prevent changes to the records in the sub
forms?

The controls on the main form should still be selectable
as they control the records pulled by the subforms.

So I guess i need to add some type of code to the
subforms then? But what is it?
 
for now you can go to the sub form properties and set not
alowed to edit, and so forth and it will lock them out
from editing the subforms..
 
DOPE! Im an idiot my properties screen was not expanded
enought to see locked (which is what I was looking for).
So im fine thanks.
 
Patrick Graham said:
I have a main form and a bunch of sub forms.

I want to let some people use the forms I created but for
now I want them only able to view records not change them.

Is there an easy way (bit of code) to add to the main
form that will prevent changes to the records in the sub
forms?

The controls on the main form should still be selectable
as they control the records pulled by the subforms.

So I guess i need to add some type of code to the
subforms then? But what is it?
Click to expand...

You can set the Locked property of the subform control (on the main
form) to Yes. Note that, if the subform allows additions, the "new
record" line will still appear on the subform, even though the user
can't enter anything in it.
 
Back
Top