MultiSelect List Boxes

[doncee]

Please point me in the direction of some good, free web based
resources\ documentation for information on developing the multi
select list boxes. Have made extensive use of the non-multi list
boxes in the past but am having problems locating good info for
writing code & using the multi select boxes. BTW am using acc
'97. Thanks for your input.
dc

[Allen Browne]

Re: MultiSelect List Boxes

If you are trying to use multi-select listboxes to store multiple option
values in a single field, don't! Instead, create a related table to hold the
related records, and use a subform.

If you are trying to use an unbound multi-select listbox as criteria, see:
Use a multi-select list box to filter a report
at:

http://allenbrowne.com/ser-50.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"doncee" <nodbcspam9814w anted@charter.n et> wrote in message
news:Xns97A8476 09DABmedbcSWBEl l@216.196.97.13 1...[color=blue]
> Please point me in the direction of some good, free web based
> resources\ documentation for information on developing the multi
> select list boxes. Have made extensive use of the non-multi list
> boxes in the past but am having problems locating good info for
> writing code & using the multi select boxes. BTW am using acc
> '97. Thanks for your input.
> dc[/color]

[doncee]

Re: MultiSelect List Boxes

"Allen Browne" <AllenBrowne@Se eSig.Invalid> wrote in
news:44435939$0 $16685$5a62ac22 @per-qv1-newsreader-
01.iinet.net.au :
[color=blue]
> http://allenbrowne.com/ser-50.html[/color]

Thanks for your reply and the example\sample. Am trying to open
several records of a table via a specific form by highliting
those records in a list box. When the record has been updated &
then form closed the next highlited record would open in the
same form for editing until each of the highlited records have
been updated. Hopefully this makes sense. This is actually
similiar to the Developers Sample Phone list that is shipped
with Access but I felt that example was pretty cheesy & was
difficult to follow the code.Thanks for any help you can offer.
dc

[Allen Browne]

Re: MultiSelect List Boxes

So the list box is being used to filter the records that need to be edited?

You could use the code in the link to OpenForm with a WhereCondition so that
it contains only the records to be edited. The user then edits the record,
steps to the next one (using the built-in navigation buttons), and so on,
going back if needed, until the selected records are done, and then closes
the form.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"doncee" <nodbcspam9814w anted@charter.n et> wrote in message
news:Xns97A84B4 0F426FmedbcSWBE ll@216.196.97.1 31...[color=blue]
> "Allen Browne" <AllenBrowne@Se eSig.Invalid> wrote in
> news:44435939$0 $16685$5a62ac22 @per-qv1-newsreader-
> 01.iinet.net.au :
>[color=green]
>> http://allenbrowne.com/ser-50.html[/color]
>
> Thanks for your reply and the example\sample. Am trying to open
> several records of a table via a specific form by highliting
> those records in a list box. When the record has been updated &
> then form closed the next highlited record would open in the
> same form for editing until each of the highlited records have
> been updated. Hopefully this makes sense. This is actually
> similiar to the Developers Sample Phone list that is shipped
> with Access but I felt that example was pretty cheesy & was
> difficult to follow the code.Thanks for any help you can offer.
> dc[/color]

[doncee]

Re: MultiSelect List Boxes

"Allen Browne" <AllenBrowne@Se eSig.Invalid> wrote in
news:44439966$0 $16685$5a62ac22 @per-qv1-newsreader-01.iinet.net
..au:
[color=blue]
> So the list box is being used to filter the records that
> need to be edited?
>
> You could use the code in the link to OpenForm with a
> WhereCondition so that it contains only the records to be
> edited. The user then edits the record, steps to the next
> one (using the built-in navigation buttons), and so on,
> going back if needed, until the selected records are done,
> and then closes the form.
>[/color]

Thanks again for your reply. Are you saying that in the line
right above Exit_Handler I should change it to an OpenForm
rather than OpenReport?? I'm not sure I follow. I'm not the
best at this sort of thing.
dc

[Allen Browne]

Re: MultiSelect List Boxes

Yep: OpenForm will open the form, and you use the WhereCondition to open it
limited to the selected records (as long as the form is not already open.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"doncee" <nodbcspam9814w anted@charter.n et> wrote in message
news:Xns97A8EFE D862B8medbcSWBE ll@216.196.97.1 31...[color=blue]
> "Allen Browne" <AllenBrowne@Se eSig.Invalid> wrote in
> news:44439966$0 $16685$5a62ac22 @per-qv1-newsreader-01.iinet.net
> .au:
>[color=green]
>> So the list box is being used to filter the records that
>> need to be edited?
>>
>> You could use the code in the link to OpenForm with a
>> WhereCondition so that it contains only the records to be
>> edited. The user then edits the record, steps to the next
>> one (using the built-in navigation buttons), and so on,
>> going back if needed, until the selected records are done,
>> and then closes the form.
>>[/color]
>
> Thanks again for your reply. Are you saying that in the line
> right above Exit_Handler I should change it to an OpenForm
> rather than OpenReport?? I'm not sure I follow. I'm not the
> best at this sort of thing.
> dc[/color]