combination listbox checkbox

[legos]

is there a way to display a list box where each entry in the listbox has a check box next to it. I want the user to be able to select if certain items in the listbox have some sort of priority.

Durible Outer Casing to Prevent Fall-Apart

 

[MD5150]

Yes, but not the editing part.

But you can simply add a [priority] field to your table and do a record edit via code from the double-click event of the list box. Your code would grab the record ID, find that record in the table, make the edit, then refresh the listbox. Or you can simply run an update query and refresh the list box if you're not into coding.

The [priority] field can be a Yes/No field giving you the check box that you want, or you can make it a number field that holds a priority number. Or simply just text that says "HOT!".

Personally, I wouldn't use a Yes/No field because it will give the user the impression that it's a fully functional checkbox. Instead, I would use priority *levels* and use a popup form displaying "Select Priority Level" also showing their descriptions.

Hope this helps,

Mike Dorthick

 

[legos]

there are only going to be two priority levels, basically urgent or not. Thanks for your help, thats a good idea

Durible Outer Casing to Prevent Fall-Apart

 

[legos]

ok, in the list box i get a yes/no display, which is fine, but i'd prefer to show a check box like it does in the table. can this be done?

Durible Outer Casing to Prevent Fall-Apart

 

[MD5150]

Actually, now that I think about it, yes, it will only show the value of the Yes/No, so I don't think you can get the actual checkbox. You'll have to use a subform.

I often want to use listboxes as well because they just look so much better than subforms, but the listbox does have its limitations.

Mike Dorthick