Disable subform's add records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I set the subform's Allow Additions = No, the subform is not visible
unless there a records. Is it possible to set a subform to NOT allow
changes, additions, and data entry but have the sub-form visible at all time
and allow navigation buttons? thanks in advance.
 
Samantha,
From the main form holding the subform, click (select) the subform. Open the
subform's properties. On the "Enabled" property, change that to "no".
 
When I set the subform's Allow Additions = No, the subform is not visible
unless there a records. Is it possible to set a subform to NOT allow
changes, additions, and data entry but have the sub-form visible at all time
and allow navigation buttons? thanks in advance.

Just set its AllowUpdates to No (instead of AllowAdditions).

John W. Vinson[MVP]
 
Back
Top