Transfer data from form to table with Yes or No field

[Akchayan]

I have this form:



And the data from this form will be transferred to this table:


I have this code for that:

Set db = CurrentDb
    Set rs = db.OpenRecordset("tblOfferte")
        With rs
            .AddNew
            
            !Bezeichnung_1 = Me!Bezeichnung1
            !Einheit_1 = Me!Einheit1
            !Anzahl_1 = Me!Anzahl1
            '!Per_1 = Me!Per1'
            !Einheitspreis_1 = Me!Total1
            !Summe_1 = Me!Summe1
  
            .Update
        End With
    rs.Close
    Set rs = Nothing
    db.Close
    Set db = Nothing

But I don't know how to make it so that when the user clicks on the radio button "Per" in the form, it is ticked in the table at "Per_1". How should I solve this?

[xps35]

Do not use a radio button but a check box.

[Gicu]

What is the name of the option (radio) button control? You should use Me. instead of Me! to get the use of Intellisense.
It should work the way you have it but also try:

!Per_1 = Iif(Me.Per1=True,-1,0) 'assumes the radion button is named Per1

Cheers,

[Akchayan]

What is the name of the option (radio) button control? You should use Me. instead of Me! to get the use of Intellisense.
It should work the way you have it but also try:

!Per_1 = Iif(Me.Per1=True,-1,0) 'assumes the radion button is named Per1

Cheers,

Thank you very much it worked!