hi,
I want make Label in subform visible, If subform's record count is zero. I don't know why It's not working. Here is my code :
Code:
Private Sub Command24_Click()
If Me.MySubform.Form.Recordset.RecordCount = 0 Then
'Msgbox "No records" - this is working
Forms![MyForm]![MySubform].Form![Label23].Visible = True - not working
'Me![MySubform]![Label23].Visible = True - this is also not working
Else
'MsgBox "There are records" - also working
End If
End Sub
Am I referencing wrong, or what is the case here ?