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

MultiSelect List Boxes

P: n/a
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
Apr 17 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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" <no*****************@charter.net> wrote in message
news:Xn************************@216.196.97.131...
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

Apr 17 '06 #2

P: n/a
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in
news:44435939$0$16685$5a62ac22@per-qv1-newsreader-
01.iinet.net.au:
http://allenbrowne.com/ser-50.html


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
Apr 17 '06 #3

P: n/a
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" <no*****************@charter.net> wrote in message
news:Xn*************************@216.196.97.131...
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in
news:44435939$0$16685$5a62ac22@per-qv1-newsreader-
01.iinet.net.au:
http://allenbrowne.com/ser-50.html


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

Apr 17 '06 #4

P: n/a
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in
news:44***********************@per-qv1-newsreader-01.iinet.net
..au:
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.


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
Apr 18 '06 #5

P: n/a
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" <no*****************@charter.net> wrote in message
news:Xn*************************@216.196.97.131...
"Allen Browne" <Al*********@SeeSig.Invalid> wrote in
news:44***********************@per-qv1-newsreader-01.iinet.net
.au:
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.


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

Apr 18 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.