Thanks! Worked perfect.
Tiffany Atchley
PO Box 1003
Fort Duchesne, UT 84026
435-722-7833
WWW.ODYSSEYMINISHETLANDS.NET
________________________________
From: acravenrohm <yahoo@craven.de>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, October 19, 2011 3:06 PM
Subject: [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
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar