Option button value problem in tableview!

[Jar80]

I have one form which is displayed in tableview, now there are text fields and one yes/no option button.

Problem is that when i press the yes/no option button then the value is true but when i press the yes/no option button in the next record then the next record get that same value.

I want that there are only one yes/no option what means that when i press option button ex. in record 1 then the value = true but when i press option button in the record 2 then the value = true but record 1 value has changed to false.

 

[Hap007]

Dear Jar80,

When you are viewing a form in table view, then controls like option buttons have only one copy of the control, so if you set this true, then it is true for all forms(lines) displayed. This happens when the option button is not assigned to a field.

To solve this problem, you need to assign the option button to a field in the record set. If you add a temporary field to your recordset and link this option button to this field, then it will work as expected.

Hope This Helps,
Hap...

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Add-on Solutions
Access Consultants forum

http://www.tek-tips.com/groups/accessDevelopers