If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Prevent duplicates in List Box
Hello ...
I have form that a clerk uses for employee's calling in sick or late. The clerk select either the sick or late check box and the cursor so to a List Box that lists all of the departments exists in a station. By typing the first letter ... etc .... This then feeds a combo box limited by the department name you selected above. It works fine ... but there are hundreds of duplicates in the list. Is there any way to prevent the dups???? Thanks and Happy New Year -- Jerry |
#2
|
|||
|
|||
Prevent duplicates in List Box
Jerry,
I assume the Row Source of the Listbox is a Query? Open the design view of the query, right-click anywhere in the upper panel of the query design window, and set the Unique Values property to Yes. See if that fixes it. If not, please post back with details of the Listbox's Row Source. -- Steve Schapel, Microsoft Access MVP Jerry Mc Cauley wrote: Hello ... I have form that a clerk uses for employee's calling in sick or late. The clerk select either the sick or late check box and the cursor so to a List Box that lists all of the departments exists in a station. By typing the first letter ... etc .... This then feeds a combo box limited by the department name you selected above. It works fine ... but there are hundreds of duplicates in the list. Is there any way to prevent the dups???? Thanks and Happy New Year |
#3
|
|||
|
|||
Prevent duplicates in List Box
On Sun, 31 Dec 2006 19:45:00 -0800, Jerry Mc Cauley
wrote: It works fine ... but there are hundreds of duplicates in the list. Is there any way to prevent the dups???? Sure. Base the combo box on a DISTINCT query to limit it to one row per value. What's the combo's rowsource, or how are you setting the dependency with the listbox? John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|