AutoFill and Queries

[Esaw]

Hello All
I have set up an 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) Could anyone
tell me if there's a way to fix it?
Here is how it's set up:
Row Source for "Style Number"
SELECT [Art].[ArtID], [Art].[StyleNumber], [Art].[StyleDescription] FROM Art;
Control Source for "Style Description" =[cboArtID].[Column](2)

Thank you so much! This site is such a help!

 

[John W. Vinson]

Hello All
I have set up an 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) Could anyone
tell me if there's a way to fix it?
Here is how it's set up:
Row Source for "Style Number"
SELECT [Art].[ArtID], [Art].[StyleNumber], [Art].[StyleDescription] FROM Art;
Control Source for "Style Description" =[cboArtID].[Column](2)

Thank you so much! This site is such a help!

Base the Report on a Query joining the Art table to the lookup table. This is
one of the many, many limitations to Microsoft's vexing Lookup Field
misfeature - it *LOOKS* like the field contains the StyleDescription but it
doesn't.

John W. Vinson [MVP]

 

[Randall Dean Lively]

Hello All
I have set up an 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) Could
anyone
tell me if there's a way to fix it?
Here is how it's set up:
Row Source for "Style Number"
SELECT [Art].[ArtID], [Art].[StyleNumber], [Art].[StyleDescription] FROM
Art;
Control Source for "Style Description" =[cboArtID].[Column](2)

Thank you so much! This site is such a help!

Base the Report on a Query joining the Art table to the lookup table. This
is
one of the many, many limitations to Microsoft's vexing Lookup Field
misfeature - it *LOOKS* like the field contains the StyleDescription but
it
doesn't.

John W. Vinson [MVP]

 

[Esaw]

Hello All
I have set up an 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) Could
anyone
tell me if there's a way to fix it?
Here is how it's set up:
Row Source for "Style Number"
SELECT [Art].[ArtID], [Art].[StyleNumber], [Art].[StyleDescription] FROM
Art;
Control Source for "Style Description" =[cboArtID].[Column](2)

Thank you so much! This site is such a help!

Base the Report on a Query joining the Art table to the lookup table. This
is
one of the many, many limitations to Microsoft's vexing Lookup Field
misfeature - it *LOOKS* like the field contains the StyleDescription but
it
doesn't.

John W. Vinson [MVP]

Thank you for getting back to me, I'm pretty new to Access, could you tell me how to get the lookup table in there? I have the Art Table and the Contract Table (the table I want info from also) and they are linked but it keeps coming up with nothing.

Thanks so much

 

[John W. Vinson]

Thank you for getting back to me, I'm pretty new to Access, could you tell me how to get the lookup table in there? I have the Art Table and the Contract Table (the table I want info from also) and they are linked but it keeps coming up with nothing.
Thanks so much

Create a new Query in the queries window.

Add the tables that you want to include - I don't know what they're all named,
you haven't said, but the Art table and the Contract table.

Their being linked in the Relationships window won't automagically cause them
to be included in a query; you need to add them to the query yourself. The
relationship should cause the query to have the tables correctly linked,
though.

John W. Vinson [MVP]

 

[Esaw]

Thanks. I've actually already done that though. Is there something that I am
missing, being I created a combo box and such?
Here is my SQL
SELECT Contracts.ArtistName, Contracts.StyleNumber,
Contracts.StyleDescription, Contracts.ClientName, Contracts.ContractStart,
Contracts.ContractEnd, Contracts.Product, Contracts.RoyaltyRate
FROM Art INNER JOIN Contracts ON (Art.ArtistName = Contracts.ArtistName) AND
(Art.StyleDescription = Contracts.StyleDescription) AND (Art.StyleNumber =
Contracts.StyleNumber);

It's not displaying the StyleNumber. It is still only displaying the ArtID.