Linking a optionbutton to a record 
Author Message
 Linking a optionbutton to a record

I have trouble linking the state of two optbuttons to a record.
I want to put the users choice (opt 1 or opt2) to a record as true or false.

I put the following code in de click event:

Private Sub SaveWedstrijdInfo()
  datWedstrijdInfo.Recordset.Edit
  datWedstrijdInfo.Recordset.Update
  With datWedstrijdInfo.Recordset
    .Edit
    .Wedstrijdnaam = txtNaamVanDeWedstrijd.Text
    .[Wedstrijd datum] = dtpWedstrijdDatum.Value
    .[Plaats wedstrijd] = txtPlaatsWedstrijd.Text
    .Website = txtWebsite.Text
    If optCategorieToekenning(0).Value = True Then
      .[Cat volgens geboortedatum] = True
    Else
      .[Cat volgens geboortedatum] = False
    End If
  End With
  datWedstrijdInfo.Refresh
End Sub

When a change the txtfields i see the changes in de database.
But when i change the optionbutton the database doesn't change.
The corresponding access fiels is a True/False field

thx in advance



Sun, 26 Sep 2004 17:02:43 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Select Unique Record Identifier problem with Linking SQL server

2. Strange Links to records

3. Can't access records with sub form for linked sub table

4. Updating a single OLE link for a record OR updating existing database

5. Link to particular record in Access database?

6. Link Auto Refresh to Max Record Date+1

7. Link Table - blank records

8. no records appear on form linked to table.

9. Convert Embedded graphic to Linked on 1000 records

10. Convert Embedded Graphic to Linked on 1000 records

11. Can't add new records when using Linked forms

12. Linking Access records to Word Documents

 

 
Powered by phpBB® Forum Software