Check boxes not working on form

[RECrerar]

I have a form with three checkboxes on it, behind the form is some code that changes the control source of the checkboxes depending on the value in anotehr field. The code seems to run okay (that is it doesn't crash) but the checkboxes on the form do not appear to be enabled. At least they don't do anything so I am assuming it is an enabled issue.

I wasn't sure whether to put this in forms or VBA, have gone with forms as fundamentaklly it is a form I am working on, hope this is the right place.

This post is linked to http://www.access-programmers.co.uk/forums/showthread.php?t=154763 which explains what I am ultimately trying to achieve. As this is a bit of a sideline issue I thought it would make sense for it to have it's own post.

I have attached the database (please note the tasks are not the actual ones the database would be used for, I am nat creating a database to help me keep track of my laundry!)

Hope someone can help. Thanks

 

[KenHigg]

I think you simply need to ref the field names with quotes:

chTask1.ControlSource = "A1"

 

[RECrerar]

Simple as that. Beautiful.

 

[KenHigg]

Note: I had to tinker with it to figure it out - Neat technique, changing the source on the fly like that.

 

[RECrerar]

Thanks,

Have uploaded the working sample database on the original thread, now to get on with sorting out the rest of this mess!