MS Access - Subform

[Milan25]

Hi,

I want to consult with users in this forum the following:

my database contains a form which includes a subform.
What command through VBA or macro I can set the action of opening the form:
1) mode of data - the addition (to form & to subform that is displayed as a data sheet)
2) mode of data - modifications (in the form of records and also a datasheet subform, which belongs to the entry of the main form).

Basically, this is the mode setting data for each subform when the main form is opened.



Milan

[jgelpi16]

Are you referring to the "AllowEdits", "AllowDeletions" and "AllowAdditions" commands? What are you trying to accomplish? Not quite sure I follow.

[Milan25]

hello,

yes, that´s it.
I have already solved my problem with this code:

Private Sub Form_Load()

If CurrentProject.AllForms("Form1").IsLoaded = False Then
Me.AllowAdditions = True
Me.DataEntry = True
Else
Me.AllowAdditions = True
Me.DataEntry = False
Me.AllowDeletions = True
Me.AllowEdits = True
Me.AllowFilters = True
End If

End Sub