F
FredK
Is there a way to hide (or not list) duplicate records that might be in a
List Box?
Thanks in advance for any help.
Fred
List Box?
Thanks in advance for any help.
Fred
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Steve
Yes, base your listbox on a query that excludes duplicates.
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]
PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
[email protected]
J
John W. Vinson
Is there a way to hide (or not list) duplicate records that might be in a
List Box?
Sure. Base the Listbox on a query with only the fields that you want to see,
and its Unique Values property set to Yes.
John W. Vinson [MVP]
Z
zionsaal
Sure. Base the Listbox on a query with only the fields that you want to see,
and its Unique Values property set to Yes.
John W. Vinson [MVP]
put the word "distinct" after the word "select" on the row source
property
F
FredK
That worked, Thanks!
put the word "distinct" after the word "select" on the row source
property