Getting rid of duplicate options in a list box

[thtone]

Hi all, I have an assignment I turned in but I got a part wrong and I cannot figure out how to correct it.

https://www.box.com/s/pt8drv3mgpbz5nx62b21

On the frmType the list box selection repeat themselves when there should only be one of each. The qryImprovedParameter is the related query.



Any help would be really appreciated, Thanks a bunch!

[June7]

If you want to show just property types, have to exclude the unique identifer then change the ColumnCount, BoundColumn, ColumnWidths properties.

SELECT DISTINCT PropertyType FROM tblProperty;

[thtone]

Got it.

I Figured out what was going wrong. I was selecting only one field on the wizard for the listbox query but it was populating it with three fields for whatever reason.

It was something easy like I thought. Deleted extra fields in list box, changed column count. Done.

Funny part is i could have sworn I tried this last night. Oh well, thanks again!

[June7]

Cross post http://forums.aspfree.com/microsoft-...-537253-2.html

Glad you found solution but don't understand how the mods you describe eliminated the duplication of property types in the RowSource. Because of the source table, would need either DISTINCT or GROUP BY query.