Solved Updating Information in 'Detail' area of Form (1 Viewer)

Local time
Tomorrow, 09:35
Joined
Sep 14, 2020
Messages
38
Hi,
I am a novice, but keen to learn more about MS Access including VBA.
I am using Office 365 Pro Plus on Windows 10 (latest update).
I am developing a small client database for myself - it has become too unwieldly using Contacts in Outlook.
I have a list (7 items) of where my clients are in the process within the Clients database.
On the Clients Form I have added seven Labels in a row, each labelled as per the Process list in the database.
I want to change the back color of the Label indicating where along the process the client is at, e.g. Lead, Setup Meeting, ... Complete
Currently I have written a Subroutine to set all seven labels to default, and then using a case statement set the relevant label back color which works.
However, my true novice skills now show themselves as I don't understand well enough where to run this subroutine from.
I am currently running it - Detail->On Paint which works, however, the routine runs every time I move the mouse over the Tabs, etc
Can someone please guide me what Event is best to run the routine?
Happy to sent to research myself as opposed to simply being given the answer - I will learn more if I know where and how to find my own answers.
Thanking you in anticipation of your support.
Regards
Peter
 

Attachments

  • Access Form.png
    Access Form.png
    355.3 KB · Views: 155

theDBguy

I’m here to help
Staff member
Local time
Today, 15:35
Joined
Oct 29, 2018
Messages
21,358
Hi. Welcome to AWF!

Just a guess but maybe try using the Form's Current event.
 
Local time
Tomorrow, 09:35
Joined
Sep 14, 2020
Messages
38
Thanks theDBguy,
Works perfectly.
Regards
Peter
 

Users who are viewing this thread

Top Bottom