Forgive me if this is posted elsewhere, but I've searched both google and this forum for the same scenario, but cannot find it.
My current project is HR related and I'm using a form that is based on a single query (most likely the root of my problem) that encompasses all of the data that I require. I'm using tab control object and inserting a subform on each tab that populates based on the value I select (in this case an employee) in a combo box on the main form above the tab control.
Some fields, which are not contained in subforms in this instance, are populating with numbers (the actual data stored) instead of the correlating value (in this case a department name) on my form. The underlying query displays the department name correctly, so I'm not sure if/how I screwed up the join. Any ideas of what I can check to resolve this lack of resolve? (sorry for the terrible pun....)