E
Esaw
I have posted this question before and not been able to figure out the issue,
so I'll try again.
I have a "autofill" set up in a subform using a combo box and text box. It
works just fine. But now that I need it to do the same thing in a query, I
don't know how to set it up. It's displaying the wrong field (primary
key/ID#) in the report and in the query only the StyleNumber.
Here is my query SQL:
SELECT Contracts.ArtistName, Contracts.StyleNumber,
Contracts.StyleDescription, Contracts.ClientName, Contracts.ContractStart,
Contracts.ContractEnd, Contracts.RoyaltyRate, Contracts.Product
FROM Art RIGHT JOIN Contracts ON (Art.StyleDescription =
Contracts.StyleDescription) AND (Art.StyleNumber = Contracts.StyleNumber)
ORDER BY Contracts.ArtistName, Contracts.ContractStart DESC;
And here is how it's set up in my subform:
Combo Box name is: ArtID
Control Source is: StyleDescription
Row Source is: SELECT [Art].[ID], [Art].[StyleNumber],
[Art].[StyleDescription] FROM Art ORDER BY [StyleNumber];
Format is: 3 columns, Column width 0",0.5",0"
Text Box Name is: StyleDescription
Control Source is: =[ArtID].[Column](2)
Could anyone help me out with this? I seem to be missing something.
Thanks!
so I'll try again.
I have a "autofill" set up in a subform using a combo box and text box. It
works just fine. But now that I need it to do the same thing in a query, I
don't know how to set it up. It's displaying the wrong field (primary
key/ID#) in the report and in the query only the StyleNumber.
Here is my query SQL:
SELECT Contracts.ArtistName, Contracts.StyleNumber,
Contracts.StyleDescription, Contracts.ClientName, Contracts.ContractStart,
Contracts.ContractEnd, Contracts.RoyaltyRate, Contracts.Product
FROM Art RIGHT JOIN Contracts ON (Art.StyleDescription =
Contracts.StyleDescription) AND (Art.StyleNumber = Contracts.StyleNumber)
ORDER BY Contracts.ArtistName, Contracts.ContractStart DESC;
And here is how it's set up in my subform:
Combo Box name is: ArtID
Control Source is: StyleDescription
Row Source is: SELECT [Art].[ID], [Art].[StyleNumber],
[Art].[StyleDescription] FROM Art ORDER BY [StyleNumber];
Format is: 3 columns, Column width 0",0.5",0"
Text Box Name is: StyleDescription
Control Source is: =[ArtID].[Column](2)
Could anyone help me out with this? I seem to be missing something.
Thanks!