How to get the representation/lookup value of field instead of its PK from recordset

[kfizz]

I have a form with a field that uses a lookup field to another table to get the representation of a foreign key when selecting data for that field. However, if I access the recordset through VGA (e.g. Me.Recordset("fk_id")) I get the actual ID which makes sense. Is there a way to get the string representation from the recordset or do I need to create a new recordset and use the ID to query the second table?

[RuralGuy]

You can join the two tables on that field and then all of the fields from both tables are available.