Hello:
I have a form that is driven by a query that looks at two tables. The data populates correctly.
I have a textbox on the form that I can either bind to the fieldname in the query, or leave unbound.
When I bind it, I cannot change the value.
When I unbind it, changing the value represents changing all the values currently on the form. Of course, the data in the underlying table is not actually changed.
I would like to simply click the box and have the table update, and potentially add some code behind it to change other things. There must be something stopping me from accomplishing this. My gut feeling is that I would need to unbind the control and have code change the actual table, which I am fine with. However, because I cannot check the boxes individually, I cannot get to this point.
Thanks in advance.