Displaying contents of another field if first is null

[SusanCB]

Hi, all. I'm creating a report that shows trainings conducted by employees.

Some of the trainings have names, stored in the field [Training Name]. Others are just categories -- such as Individual Consultation -- and are stored in [EBP Training Category].

In the report, if the [Training Name] field is null, I would like to display the contents of [EBP Training Category] in the same location.

Thoughts on how best to do this? Thanks!

 

[SusanCB]

D'oh! As so often happens, I figured out a solution right after I posted this. I put the following code an the AfterUpdate box on the form one uses to enter EBP Trainings. Works perfectly.

Private Sub EBP_Training_Category_AfterUpdate()

Me.[Training Name] = Me.EBP_Training_Category.Column(1)

End Sub