Adding and deleting records based on a checkbox

[Sentosa]

Hi all,

I'm new to this so please be a little bit patient with me :-)

I have the following problem of which I thought i could solve it easily.... But I'm sad to say I can't find the solution. And I have been going at it for a few days now.....

I have a form with a few checkboxes and a table with fields ID=counter, buro=number and dienst=number.
When the box on the form is checked a record should be added to the table (for example buro=2 and dienst=5) and when the box is unchecked this record should be deleted.

Can someone please help me with this because I seem to be going around in circels....

I would be very thankfull for any help.....

Marcel

[overcomer]

please try the logic below:

If CheckBox.Value = 0 Then
    str_sql = "Delete from table where field1 = " & buro & " and field2 = " & dienst
Else
    If CheckBox = -1 Then
        str_sql = "Insert into table(field1, field2) values(" & buro & ", " & dienst & ")"
    End If
End If
 
Docmd.RunSQL str_sql
 
 

[Sentosa]

This works like a charm....
I am a happy person.
Thank you so much for your help.