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.
How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted. Others take a little more time and effort and often providing a sample database is very helpf…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referential integrity:
Decide if you want cascade upda…