Hi gang, i've been out of the database world for a few years now and drawing a blank on how to accomplish this.
I have a form im using for a dashboard (frmdashboard) that has a form called frmteamneeds and a form called frmteamselections. Frmteamneeds is pulling from tblTeamNeeds which has TeamID and Position are related data fields for qryTeamDraft.
when a team gets a position filled i want that position to highlight or change font color (conditional formatting) on my frmteamneeds form. I did try using conditional formatting where the field value is equal to Forms![frmDashboard]![frmTeamDraft].Form![POS] however it only works for the first selected position. I believe I need a dlookup with a where claus but can't figure out how to make it work.