I am in the process of building a DB for employees training records.
I have a main form named frmUpdateTraining which has a sub form name subfrmTrainingTimes which is a continuous form.
On the main from there is a text field named Date_Taken. On the sub form there is a text field named TrainingDate.
What I would like to do is if the text field TrainingDate is null then the text field Date_Taken is not visible and if the text field TrainingDate contains a date then the text field Date_Taken is visible.
I have tried using the following code, but it is not working, can anyone help me out please?
If Is Null[subfrmTrainingTimes]![TrainingDate] then
Me.Date_Taken.Visible = False
Else
Me.Date_Taken.Visible = True
End If
Hope that makes sense.