I tried this a couple different ways but it's just not working. I want a label or text box to show a different string depending on whether or not a field in the current record contains anything. The label pertains to a subform whose record source is a subset table to the main table. Clear as mud?
I tried putting this code in the Form_Activate event of the subform, but it didn't work:
So then I stuffed it into the click event of a button and it worked fine.
How do I get the text or caption to change whenever the form is pulled up or the user navigates to a new record? Should the code go in the Main form or the SubForm or into a module somewhere?
Thanks in advance,
Onwards,
Q-
I tried putting this code in the Form_Activate event of the subform, but it didn't work:
Code:
If IsNull(Me.SimTemplateID) Then
Me.TemplateExists.Caption = "Template is Chosen"
Else
Me.TemplateExists.Caption = "Template is Missing"
End If
So then I stuffed it into the click event of a button and it worked fine.
How do I get the text or caption to change whenever the form is pulled up or the user navigates to a new record? Should the code go in the Main form or the SubForm or into a module somewhere?
Thanks in advance,
Onwards,
Q-