Update on what I ended up doing. I used a combo box that referenced my linked table with a query. I included the additional values I needed in that query as well. Then I used the change event for the combo box to populate the other fields!
Shout out to Aytee and Orange for getting me googling in the right direction.
After creating the combo box, here is the code that I Used to fill the additional fields. cboChoice is obvs the combo box. It is 0 based, so...Column1 is actually the 2nd column.
Code:
Me.txtBox1.Value = Me.cboChoice.Column(1)
Me.txtBox2.Value = Me.cboChoice.Column(2)
Me.txtBox3.Value = Me.cboChoice.Column(3)