Hi AccessWorld Team,
From the Database1 file that I'm woriking, I created a form called "Dashboard" and added 3 text boxes. The value of these 3 text boxes should be taken from the value of the text box "Average" from the forms namely "FCust_A", "FCust_A", "FCust_A" which are different forms.
I use the formuala "=[Forms]![FCust_A]![Average]" to get the value from other forms but the value display is "#Name?"
I attached the sample database.
Request:
1. Please correct the formula that I used to display the correct value in Dashboard form text boxes.
2. Once the correct value is display, I need to create a Vertical chart from the 3 values. Not sure if Vertical chart is possible in access but if it is, can you please help me to do it in this sample attachment.
Thank you
From the Database1 file that I'm woriking, I created a form called "Dashboard" and added 3 text boxes. The value of these 3 text boxes should be taken from the value of the text box "Average" from the forms namely "FCust_A", "FCust_A", "FCust_A" which are different forms.
I use the formuala "=[Forms]![FCust_A]![Average]" to get the value from other forms but the value display is "#Name?"
I attached the sample database.
Request:
1. Please correct the formula that I used to display the correct value in Dashboard form text boxes.
2. Once the correct value is display, I need to create a Vertical chart from the 3 values. Not sure if Vertical chart is possible in access but if it is, can you please help me to do it in this sample attachment.
Thank you