Using a lookup column as row source

[ddivney]

I'm trying to set up a combo box that will search my records and I've gotten it to work, however I'm trying to fix the values it displays.



The row source for the combo box is

SELECT [Match].[MatchID], [Match].[Home], [Match].[Away] FROM [Match];

, with the fields Home and Away being lookup fields themselves, with rowsources

SELECT [Team].[TeamID], [Team].[TeamName] FROM Team;

.

So the search combo box displays MatchID, Home and Away fine, but it shows the TeamID column of Home and Away, and I would like it to show the TeamName column. Is there a way to use the column function (i.e. Column(#)) in the row source?

[June7]

I don't think so. The RowSource sql is pulling values from table field. The column index is a property of combo and list boxes on form.

Make the combobox RowSource a query that joins tables so that all related data is available.

Want to provide db for analysis? Follow instructions at bottom of my post.