listbox and checkbox

[aw23]

I need to create a list of tasks (taken from a db) with a checkbox next to each one. If the task is done, the user will enter a check and I need to make an indication in the db. So the checkbox has to be linked to the list. I thought I could do a listbox with the lst and then create the checkboxes in a loop next ot the list. But then the checkbox is not connected to the list and how can I know which item in the list the box is referring to? Is there a better way to do this?

Thanks

 

[KenReay]

Hi

"I need to create a list of tasks (taken from a db) "

do you mean (taken from a table) ??

if yes, why not include the check box in the table (ie add a yes/no column), and use a simple bound sub form to list the tasks and allow the user to update by ticking the box

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[aw23]

Hmmm...how do I do that? I have my table set up like that. How do I create a simple bound subform?

Thanks

 

[KenReay]

Hi

Use the Form design wizard to create the form (probably in datasheet view, but that is up to you)

on the main form, create a subform control (using the toolbox), and choose the above form as the form to place in the subform control (ie the .source property)

The wizards will do it all for you



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK