By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,165 Members | 894 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,165 IT Pros & Developers. It's quick & easy.

Listbox question

P: n/a
I have the following table: (there are more fields, but I will keep it
short)

AgencyCode GAName
5T Smith, Todd
5T Smith, John
3S Jones, Sara

I want to construct a listbox, but each agency should only have one
line:

AgencyCode GANames
5T Smith, Todd;Smith, John
3S Jones, Sara

This possible ?
Thanks,
Brian

Dec 21 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Might I ask what you are attempting to accomplish with the ListBox you
describe? For every reason that has come to mind for me, I've thought that
there is an easier way.

Larry Linson
Microsoft Access MVP
"BerkshireGuy" <be*************************@yahoo.comwrote in message
news:11**********************@42g2000cwt.googlegro ups.com...
>I have the following table: (there are more fields, but I will keep it
short)

AgencyCode GAName
5T Smith, Todd
5T Smith, John
3S Jones, Sara

I want to construct a listbox, but each agency should only have one
line:

AgencyCode GANames
5T Smith, Todd;Smith, John
3S Jones, Sara

This possible ?
Thanks,
Brian

Dec 21 '06 #2

P: n/a
Larry:

The listbox will be used as a selection to pass the parameter (agency)
to a report. However, the agency can have more than one GA (as
described in my sample) and this would like all agencies listed and the
GAs together.

Thanks,
Brian

Larry Linson wrote:
Might I ask what you are attempting to accomplish with the ListBox you
describe? For every reason that has come to mind for me, I've thought that
there is an easier way.

Larry Linson
Microsoft Access MVP
"BerkshireGuy" <be*************************@yahoo.comwrote in message
news:11**********************@42g2000cwt.googlegro ups.com...
I have the following table: (there are more fields, but I will keep it
short)

AgencyCode GAName
5T Smith, Todd
5T Smith, John
3S Jones, Sara

I want to construct a listbox, but each agency should only have one
line:

AgencyCode GANames
5T Smith, Todd;Smith, John
3S Jones, Sara

This possible ?
Thanks,
Brian
Dec 22 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.