Query/Table issue

[Esaw]

I have set up a combo box and autofill to display the Style Description as I
enter a
Style Number. Which works great in the subForm. But now I want to run queries
using the Style Number and in my table only the ArtID is displayed and I
can't pull the info I need (Style Number and Style Description)

I've also run the query with only one table (Contract) which will display
the ArtID instead of the StyleNumber. Then when I add the Art Table to the
query, the query pulls nothing. The query is blank. Below is how things are
set up, including both tables in the query.

Row Source for the StyleNumber: (in the subform)
SELECT [Art].[ID], [Art].[StyleNumber], [Art].[StyleDescription] FROM Art
ORDER BY [StyleNumber];
Bound Column is 1

Control Source for the StyleDescription:
=[ArtID].[Column](2)

Here's my Query:
SELECT Contracts.ArtistName, Contracts.StyleNumber,
Contracts.StyleDescription, Contracts.ClientName, Contracts.ContractStart,
Contracts.ContractEnd, Contracts.RoyaltyRate, Contracts.Product
FROM Art INNER JOIN Contracts ON (Art.StyleNumber = Contracts.StyleNumber)
AND (Art.StyleDescription = Contracts.StyleDescription)
ORDER BY Contracts.StyleNumber, Contracts.ContractStart DESC;

Thanks for any help with this.