A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Multi-Select Listbox with Check Boxes



 
 
Thread Tools Display Modes
  #1  
Old April 17th, 2008, 07:19 PM posted to microsoft.public.access.forms
Jim
external usenet poster
 
Posts: 1,404
Default Multi-Select Listbox with Check Boxes

I would like to create a multi-select list box that displays a check box to
the left of each item in the menu. The user would use the check box to
select/deselect the item rather than the standard highlight method. The
values in the list box would be dynamic based on other selections the user
has made on the form.

I'm sure this has been asked before but I could not find it...

Thanks in advance,

Jim
  #2  
Old April 17th, 2008, 09:05 PM posted to microsoft.public.access.forms
Klatuu
external usenet poster
 
Posts: 7,074
Default Multi-Select Listbox with Check Boxes

Can't be done.
An alternative would be a subform.
--
Dave Hargis, Microsoft Access MVP


"Jim" wrote:

I would like to create a multi-select list box that displays a check box to
the left of each item in the menu. The user would use the check box to
select/deselect the item rather than the standard highlight method. The
values in the list box would be dynamic based on other selections the user
has made on the form.

I'm sure this has been asked before but I could not find it...

Thanks in advance,

Jim

  #3  
Old April 17th, 2008, 09:36 PM posted to microsoft.public.access.forms
Jim
external usenet poster
 
Posts: 1,404
Default Multi-Select Listbox with Check Boxes

Klatuu,

How would I use a sub-form?

Thanks,

Jim

"Klatuu" wrote:

Can't be done.
An alternative would be a subform.
--
Dave Hargis, Microsoft Access MVP


"Jim" wrote:

I would like to create a multi-select list box that displays a check box to
the left of each item in the menu. The user would use the check box to
select/deselect the item rather than the standard highlight method. The
values in the list box would be dynamic based on other selections the user
has made on the form.

I'm sure this has been asked before but I could not find it...

Thanks in advance,

Jim

  #4  
Old April 17th, 2008, 09:53 PM posted to microsoft.public.access.forms
Klatuu
external usenet poster
 
Posts: 7,074
Default Multi-Select Listbox with Check Boxes

It would be very similar to using a list box. You could probably use the
same query you use for the list box' row source as the subform's recordsourec
and add a calculated field to the query to use for the check box. Then on
the subform, put a check box control and bind the calculated field to it.

Then instead of using the List Box's ItemsSelected collection, you would use
the subform's recordsetclone properties to loop through each row and do what
you want when the box is checked. You probably want to set the other
controls' Enabled properties to No and Locked properties to Yes in the
subform.
--
Dave Hargis, Microsoft Access MVP


"Jim" wrote:

Klatuu,

How would I use a sub-form?

Thanks,

Jim

"Klatuu" wrote:

Can't be done.
An alternative would be a subform.
--
Dave Hargis, Microsoft Access MVP


"Jim" wrote:

I would like to create a multi-select list box that displays a check box to
the left of each item in the menu. The user would use the check box to
select/deselect the item rather than the standard highlight method. The
values in the list box would be dynamic based on other selections the user
has made on the form.

I'm sure this has been asked before but I could not find it...

Thanks in advance,

Jim

  #5  
Old April 17th, 2008, 10:15 PM posted to microsoft.public.access.forms
Jim
external usenet poster
 
Posts: 1,404
Default Multi-Select Listbox with Check Boxes


Klatuu,

Thanks for the direction...

Thanks,

Jim

"Klatuu" wrote:

It would be very similar to using a list box. You could probably use the
same query you use for the list box' row source as the subform's recordsourec
and add a calculated field to the query to use for the check box. Then on
the subform, put a check box control and bind the calculated field to it.

Then instead of using the List Box's ItemsSelected collection, you would use
the subform's recordsetclone properties to loop through each row and do what
you want when the box is checked. You probably want to set the other
controls' Enabled properties to No and Locked properties to Yes in the
subform.
--
Dave Hargis, Microsoft Access MVP


"Jim" wrote:

Klatuu,

How would I use a sub-form?

Thanks,

Jim

"Klatuu" wrote:

Can't be done.
An alternative would be a subform.
--
Dave Hargis, Microsoft Access MVP


"Jim" wrote:

I would like to create a multi-select list box that displays a check box to
the left of each item in the menu. The user would use the check box to
select/deselect the item rather than the standard highlight method. The
values in the list box would be dynamic based on other selections the user
has made on the form.

I'm sure this has been asked before but I could not find it...

Thanks in advance,

Jim

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:47 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.