[MS_AccessPros] Re: creating a drop down box and....

 

Sounds like you need to set the Combobox Rowsource to "SELECT DISTINCT [model] FROM [QRYAssets]"

--- In MS_Access_Professionals@yahoogroups.com, "cc0623" <cc0623@...> wrote:
>
> I created a drop down box on my form and set it to get the data from a table. The problem is it pulls ALL of the data in that field and I do not want duplicates in the list. How do I tell it no duplicates?
>
> Thanks,
> Tiffany
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (4)

Recent Activity:

• New Members 8

Visit Your Group

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___