Displaying contents of another field if first is null

SusanCB

Registered User.
Local time
Yesterday, 19:22
Joined
Mar 10, 2010
Messages
34
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!
 
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
 

Users who are viewing this thread

Back
Top Bottom