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.
Click to expand...

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

John W. Vinson[MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

FORM-SUBFORM DATA ENTRY MODE PROBLEM!! 4
No fields in SubForm 16
Unremovable horizontal scroll bar on subform 1
Making Subform Visible On One record Only 2
Testing Subform Records to make button visible 1
First Subform record gets modified when closing form 3
populate to all rows in the subform 4
Can't edit subform - main form should not be edited. 2

Back
Top