Coloring report records based on a form's combobox selections

Punice

Registered User.
Local time
Today, 11:18
Joined
May 10, 2010
Messages
135
Using Access 2007. I have a form (Broker), with a combobox (cboClassifier), that I use to select 1 of 4 phrases, display the selected phrase and color the field with a color that I've assigned to each phrase.
Next, I have a report that contains all of the Broker names, addresses, etc. based on a query (qryBroker). I need the vba or whatever that colors the matching records based on the phrase selected by the combobox on the form, when the report is opened.
 
You can use Conditional Formatting or VBA code in the detail section's format event.
 

Users who are viewing this thread

Back
Top Bottom