I have a form with a list box which gets its values from a lookup table.

Upon submit, the form provides input to an append query.

Column1 is bound and works fine.

However, I also need Column2 in the query. How do I reference Column2 in the
query?

[Forms]![frmNewPO]![frmBoxFactory] is the control reference and that gives
me Column1 as expected.

The column I need from the lookup table is [Prefix]

I'm trying [Forms]![frmNewPO]![frmBoxFactory].[Prefix] and it's not working.

So, maybe the question is "How do I bind 2 columns in the list box?"

thanks