F FredK Jun 17, 2007 #1 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
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
S Steve Jun 17, 2007 #2 Yes, base your listbox on a query that excludes duplicates. PC Datasheet Providing Customers A Resource For Help With Access, Excel And Word Applications (e-mail address removed)
Yes, base your listbox on a query that excludes duplicates. PC Datasheet Providing Customers A Resource For Help With Access, Excel And Word Applications (e-mail address removed)
J John W. Vinson Jun 17, 2007 #3 Is there a way to hide (or not list) duplicate records that might be in a List Box? Click to expand... 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]
Is there a way to hide (or not list) duplicate records that might be in a List Box? Click to expand... 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 Jun 18, 2007 #4 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] Click to expand... put the word "distinct" after the word "select" on the row source property
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] Click to expand... put the word "distinct" after the word "select" on the row source property
F FredK Jun 18, 2007 #5 That worked, Thanks! put the word "distinct" after the word "select" on the row source property Click to expand...
That worked, Thanks! put the word "distinct" after the word "select" on the row source property Click to expand...
