Valentino54
New member
- Local time
- Today, 13:41
- Joined
- Mar 30, 2020
- Messages
- 12
Hi, need a little help. I've got the following code where the DoCmd.GoToRecord stops the flow whit runtime error 2493.
I tried diffferent ways to write it but couldn't sort it out.
I need to open a Table, find a specified record and modify the value of a check box. Is there a syntax error?
I tried diffferent ways to write it but couldn't sort it out.
I need to open a Table, find a specified record and modify the value of a check box. Is there a syntax error?
intIDGiocatore = Me.ID_Giocatore
Dim rstEsclusione As DAO.Recordset
Set rstEsclusione = dbsGestione.OpenRecordset("tblGIOCATORI")
rstEsclusione.Edit
DoCmd.GoToRecord [rstEsclusione]![ID_Giocatore] = intIDGiocatore
If Me.txtMotivoUscita = "Decesso" Then
rstEsclusione![EsclusoClub] = True
rstEsclusione.Update
End If
If Me.txtMotivoUscita = "Dimissioni dal Club" Then
rstEsclusione![EsclusoClub] = True
rstEsclusione.Update
End If
rstEsclusione.Close
Set rstEsclusione = Nothing