Checkbox output to text in table record?

[coronatus]

Hello,



I hope someone understand this. For me it's hopeless...

I have tried much in vb code. I know nearly nothing about it.
But the only thing what I want is here:

In the form if the checkbox is checked the record in the table has to change in text. When checkbox is unchecked the the record in the table must be empty too. I have 5 checkboxes for one column.

The thing what is frustrating me is that when I click on one checkbox the other checkboxes are checked too, but I want only one checkbox checked and the others unchecked. But each checkbox have to put difference text into the table record of one column.

Thanks

[Rainlover]

Have you considered using a Combo Box instead and simply select what Text you want.

[coronatus]

No, simply because I want to check it, like this :

chkbox chkbox chkbox chkbox chkbox
Very low, Low, Medium, High , Very high

But tnx for advice.

[Rainlover]

The thing what is frustrating me is that when I click on one checkbox the other checkboxes are checked too, but I want only one checkbox checked and the others unchecked. But each checkbox have to put difference text into the table record of one column.

I can't understand this one. Does your form only show a single record. Are the Checkboxes bound to the table?

[Missinglinq]

No, simply because I want to check it...

Sorry, but that answer makes no sense! You want to bind five Controls, whose Values are either 0/-1 or True/False, to a single Field, and have it store Text?

Why in the world wouldn't you want to use a Combobox that is Bound to the Field, with a Value List of Very low, Low, Medium, High, Very high?

It can be done, but it'll require a bunch of needless code!

Linq ;0)>

[coronatus]

explains the form design of the checkboxes

[coronatus]

Maybe this images explains it better. The textbox is only for testing under the checkbox, it's gone after this works.

Rainlover@ I had the all checkbox bounded to the one table control element Urgent