PLEASE HELP !

[Guest]

Hi,
I'm designing a report based on a form which includes a multi-select list
box . The values displayed in the list box come from a query based on a
table which contains 300 customer addresses all over AU.

My problem is that the field I want to display in the list box is the
States, and when it displays on my form, I see 5 states displayed 300 times
(one for each of my addresses), but I want them to display only once, so the
user can select which State or State they want to display results for on the
report.

I just don't know how to make that field display the States only once. Any
ideas would be greatly appreciated !

Thanks,

Sonja.

 

[Jeff Boyce]

I assume you are using a query to fill the listbox. If your query is only
returning the "State", you can make that query return only unique values by
using the Unique Values property.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[fredg]

Hi,
I'm designing a report based on a form which includes a multi-select list
box . The values displayed in the list box come from a query based on a
table which contains 300 customer addresses all over AU.

My problem is that the field I want to display in the list box is the
States, and when it displays on my form, I see 5 states displayed 300 times
(one for each of my addresses), but I want them to display only once, so the
user can select which State or State they want to display results for on the
report.

I just don't know how to make that field display the States only once. Any
ideas would be greatly appreciated !

Thanks,

Sonja.

Set the RowSource property of the List Box to a Select Distinct query:
Select Distinct [State] from YourTable Order By [State]

As there are 50 states, it might be neater, space wise, to use a Combo
box rather than a List box.