Peter Peterson
Member
- Local time
- Today, 20:07
- Joined
- Sep 14, 2020
- Messages
- 38
Good morning,
I am using MS Office 365 Pro on the latest version of Windows 10.
I have searched AWF and Google without success - might be my choice of keywords is the issue.
I have used rectangles to track the stage through my process a client is at (see attached image).
The rectangles are unbound.
The "process" is a list in the Clients table.
I have used 'On Click' event to:
1. Change the colour of the old rectangle to light blue and text dark blue (actually, I change all the rectangles to this);
2. Change the colour of the selected rectangle to dark blue and text white and bold;
3. change the 'clientProcess' field in the Clients table to reflect the selected rectangle (i.e. the process);
All of the above works fine, however, I have six "On Click" event procedures, one for each rectangle.
What I want to do is have one procedure called regardless of which rectangle was selected and using a Case Statement update the 'clientProcess' field and rectangle colours depending upon which rectangle was selected.
Is there a way to test which rectangle (or object) was clicked?
In the On Click event (Properties Windows), which reads "[Event Procedure], can I write my own Procedure Name including a value to pass?
If so what is the format?
Thanking you
Peter
I am using MS Office 365 Pro on the latest version of Windows 10.
I have searched AWF and Google without success - might be my choice of keywords is the issue.
I have used rectangles to track the stage through my process a client is at (see attached image).
The rectangles are unbound.
The "process" is a list in the Clients table.
I have used 'On Click' event to:
1. Change the colour of the old rectangle to light blue and text dark blue (actually, I change all the rectangles to this);
2. Change the colour of the selected rectangle to dark blue and text white and bold;
3. change the 'clientProcess' field in the Clients table to reflect the selected rectangle (i.e. the process);
All of the above works fine, however, I have six "On Click" event procedures, one for each rectangle.
What I want to do is have one procedure called regardless of which rectangle was selected and using a Case Statement update the 'clientProcess' field and rectangle colours depending upon which rectangle was selected.
Is there a way to test which rectangle (or object) was clicked?
In the On Click event (Properties Windows), which reads "[Event Procedure], can I write my own Procedure Name including a value to pass?
If so what is the format?
Thanking you
Peter