Display text field on main form depending on value of text field in sub form

[mick3911]

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.

[ranman256]

Use the PICKER, to get the path correct....
prob:

txtDate.visible= not isnull(forms!fMyform.txtTrainDate)

[mick3911]

Hi ranman,

How do you mean "Use the Picker"?

Have tried your suggested code to no avail.

[mike60smart]

Hi Mick

Logic would have it that you select a Training Name in the Main Form
Then in the subform you would have the date taken with Times.

This covers the process of 1 Training name can be attended on Multiple days.

[mick3911]

Hi Mike,

I get what you are saying.

The subfrmTrainingTimes is a continuous from because there could be more than one training session on different days.

The Date_taken field is completed when all the training has been completed. My reason for not displaying the Date_Taken field is to force Users to complete at least one record in the subfrmTrainingTimes.

[Gicu]

Not sure if it is because of the forum (you should always use the CODE tags when posting code), but you have an extra space (and missing parenthesis). Please try this:

If IsNull(Me.[subfrmTrainingTimes]![TrainingDate]) then
        Me.Date_Taken.Visible = False
Else
        Me.Date_Taken.Visible = True
End I

This will always reference the first record of the subform. To show the latest date taken you would need to sort the subform descending by the TrainingDate.

Cheers,

[mick3911]

Thanks Gicu, that works great, much appreciated.

[Gicu]

You're very welcome, good luck with your project!
Cheers,