I have an existing Report that has address data in the title at the top that comes from a single record in an address table. The user wants a different phone number to show in the title based on the type of detail record reported on in the detail section. I have added a 2nd phone number field to the address table.
I don't know what to put in the Control Source for the phone number in the title. Right now it is the name of the original phone number field in the address table.
If I need VB code I am not sure what event to attach the code to.