Thread: DropDownList..
View Single Post
 
Old October 19th, 2004, 07:50 AM
SerranoG SerranoG is offline
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

I'm not sure what you're asking, but if you create a combobox in a form, you can set its Rowsource Type as Table/Query and then make its Recordsource as an SQL statement. That is

SELECT DISTINCT Field FROM Table WHERE Criteria ORDER BY Field

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division