Link to Sharepoint List Column 'People'

[Chris]

Hi,

I have a sharepoint list, with a people column.
In Access (07) I am building a search form for reports and want to create a
dropdown that gets it data from this people column, so the user can select
names to filter by.

When I create the dropdown, and try and use it. The dropdown displays
numbers instead of the names, if I run the query behind the dropdown it
displays the names.

Is there a way to use the people column in my sharepoint list, and then use
this column on an Access Form dropdown and have it display the name?

thanks,