UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Populating A Combo Box From A Table Without Duplicates    
 
   
invisage13
post Dec 9 2010, 01:44 AM
Post #1

UtterAccess Member
Posts: 21
Me again with yet another question (IMG:style_emoticons/default/crazy.gif)

Used the combobox wizard to create a combobox that references a list of suburbs from a table. Only problem is that there are of course records that contain the same suburb and so when you use the drop down list you see multiples.

What would be the best method to avoid the dup data?

Thanks once more.
Go to the top of the page
 
+
dblife
post Dec 9 2010, 02:04 AM
Post #2

UtterAccess Veteran
Posts: 378
From: South Shields, England
Highlight the combo in design view, go to rowsource and use a query as the rowsource, change the view to sql view and after select, write 'distinct'
Go to the top of the page
 
+
invisage13
post Dec 9 2010, 02:22 AM
Post #3

UtterAccess Member
Posts: 21
QUOTE (dblife @ Dec 9 2010, 03:04 PM) *
Highlight the combo in design view, go to rowsource and use a query as the rowsource, change the view to sql view and after select, write 'distinct'


too easy. just a wealth of knowledge (IMG:style_emoticons/default/smile.gif)

This post has been edited by invisage13: Dec 9 2010, 02:22 AM
Go to the top of the page
 
+
« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 19th May 2013 - 07:51 AM