How to make a subform "read only"

  • Thread starter Thread starter DontKnow
  • Start date Start date
D

DontKnow

Hi Guys,

How would I make a subform readonly so that I am able to look at the
controls within a subform but simply not able to update/change them on a
datasheet view?

many thnaks for your help?

Cheers
 
Open the subform in design view.

Set its Allow Edits property to No.

Alternatively, set the Locked property of the text boxes to Yes.
 
Ok, look closely at the Data properties section (this is where you make
changes). There will be two properties on those fields (allow deletions) &
(allow additions). Change their properties to NO; this should stop users
from adding and deleting records.

Ryan---
 
Just set the subform control's locked property to Yes (True). That should
prevent all changes on the subform. You might want to make sure the subform
control has its enabled property set to true.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 
tHanks guys for that input!!

I was wondering how the best way to do this using VBA ?
 
DontKnow -

If you are in the main form, do this (substitue your subform name):

Me.subformName.Enabled = True
Me.subformName.Form.AllowEdits = False
 
Back
Top