Combo Box help needed

[jeo]

I have a drop down box which I created from the drop down wizard. This drop down is based on a table Functional Areas which contains a primary key for each Functional Area and a name of the Functional Area. Right now on the screen in displays the name of the Functional area, but it stores the value in the FunctionalAreaID (primary key of that table). When I use that field on my report, it just displays a value of the ID (numeric), but what I want it to display is the actual name of the Functional Area. Is this possible at all?
If more explanation is needed, please let me know.
Thanks for all the help!

 

[Ukraine82]

Make a (wizard) combo box again when selecting two fields such as FunctionalAreaID and name of Functional Area. Check the Hide Key Column (Recommended).

hth,

Michael

 

[jeo]

I already tried that as well.
Now my combo box only displays the PK. I see both columns, but only the PK value stays...
Any other ideas?
Thanks.

 

[Ukraine82]

What does your row source say in the combo box property?

Try something like this...SELECT [YourTable].[name of Functional Area Field] FROM [YourTable];

hth,

Michael

 

[jeo]

SELECT tblFunctionalAreas.FAID, tblFunctionalAreas.Functiona_Areas FROM tblFunctionalAreas ORDER BY tblFunctionalAreas.Functiona_Areas;

This is what it has.

 

[Ukraine82]

Try pasting the sql below on row source combo box. If it doesn't work, you might want to attached the database.

(I'm guessing Functiona_Areas is not a primary key)

SELECT [tblFunctionalAreas]. [Functiona_Areas] FROM [tblFunctionalAreas]
ORDER BY [tblFunctionalAreas].[Functiona_Areas]

hth,

Michael

 

[jeo]

I will try and play around before I waste any more of your time.
I will post again if I absolutely can't figure it out myself.