How do you add IF-formulas in MS Access Table/Form List Box (or Auto-populate a list?)

[Mabbie]

Hi! I'm new at using MS Access. My team needed a task tracker that would encompass various task groups so I decided to use a Task Management template to create an MS Access database.

Under one task group, we have a number of sub-groups that currently keeps one excel file tracker each. For example: Task Group A, is further divided into sub-groups Apple, Amber and Alcove. Each sub-group keeps one excel file tracker (Apple Tracking sheet; Amber Tracking sheet; etc.), and each sub-group has a different set of tasks and members.

Since I'm replacing the handful of excel trackers with one MS Access database, I'm planning to use a form with list boxes where you select a group, and the selection for the sub-group auto-populates with the corresponding sub-group.

Ex: If I select Group A, in "Group"; the list/combo box for "Sub-group" should only show Apple, Amber or Alcove.

I've tried using Query, and it worked fine until I ran a report. Instead of showing "A" and "Apple", it showed the corresponding Key/ID number.

So I was wondering if instead of using Query, I can use an IF-statement/expression instead to accomplish my goal.

Would you know how this can be done?
Or would you know if I could have missed something when I did the Query that made numbers show up instead of the text?

THANKS!!!