Ok i have a form that has a subform which has a subsubform.
I have this code right here in my sub form:
Code:
Private Sub Form_Dirty(Cancel As Integer)
'enable changes button
Me!btnUndoIndividualBorrower.Enabled = True<====ignore this part!
If Form_AddNewBorrower.Dirty Then
Me!addnewrecordborrower.Enabled = True
End If
End Sub
My main form name is AddNewBorrower.
However it is not working. What I want to do is that once the main form is filled, then the add record button in the subform will be enabled. THis is because for some reason my subforms and subsubform enable the users to enter records without even entering information in the main form. I have linked the tables but i dont know why access still allows subform records to be entered without any main form info..So it would be best if the button only activates once user entered main form info