Displaying text value vs. stored ID value

[PaveFE]

Hello again.

Hopefully this is something simple.

Background info:
I have a form, which has combo boxes to lookup values from other tables (tblPlatformTypes and tblPlatforms) and stores that data in the table the form was created from (tblUnits). The table (tblUnits) stores the IDs of from the lookup tables.

Now, I'm creating another form for a different table (tblMissionAirAssets) that has the following fields:
txtMissionAirAssetsID (PK)
txtMissionID (FK from tblMissions)
cboUnitID (FK from tblUnits)
txtPlatformType
txtPlatform

The user selects their Unit from cboUnitID, which the populates the txtPlatformType and txtPlatform fields. However, these two fields only display the IDs that are stored in tblUnits, since that's what's stored in that table.

However, I would like for the actual text value of the IDs to show, not the IDs. Is there a way to do that? I'm thinking a query may need to be created, but not sure how to go about that.
Any help would be greatly appreciated.

Thank you,

Vince

 

[PaveFE]

Found help in another forum.

Solution was as simple as making the other txt boxes combo boxes, the changing the column widths.

Thanks anyways.

Is there a way to mark this solved?