Hi,
I want to perform some action when Userform has 0 record count on Main Form load event. It's not working, whatever reference I use for subform
Here It is (here I tried only to set Dataentry to true, so that fields of subform would appear If there are no records - otherwise It returns me only labels of fields...continous subform, tabular design):
Code:Private Sub Form_Load() If Me.MySubform.Form.Recordset.RecordCount = 0 Then Me.MySubform.Form.DataEntry = True End If End Sub
However, this Main form is opened from another form via cmdbutton (simple Docmd.OpenForm, but with desired .Recordsource), maybe that is problem in reference ?