troubleshooting Question

Conditional Format & VLOOKUP (Maybe) on Access 2007 Form Redeux

Avatar of Anne Troy
Anne TroyFlag for United States of America asked on
Microsoft Access
25 Comments1 Solution421 ViewsLast Modified:
Preamble:
Please, no comments on the fact that this DB doesn't follow general standards. I can't help that right now. I created previous questions and have attempted to take direction from them of creating relationships and using queries, and none of this worked. A lot of time was put into those responses, so I awarded those experts and now I must move on.  If you can DO THIS FOR ME, great. Otherwise, I'll have to live without it. It must be done in Access 2007 and provided in accdb file format. If necessary, I can be available by phone.

Question:
On the Issue Details form, I would like to conditionally format the "Assigned to" textbox to be fill/back color yellow if the machine's username matches the current user's username in the Contacts list. The dropdown currently contains a combo box with first and last name from a query called Contacts Extended. I did add Username to that query. I just don't know how to proceed.

Thanks so much for your time.
Issues3.accdb
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 25 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 25 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros