Adding multiple check boxes in a form

[Naqibullah]

Yes i have given all the fields same to same as i have seen your example, here is the error
Private Sub Form_Current()
CurrentDb.Execute "UPDATE tblVehicle SET CheckedVehicles = False "
If Not Me.NewRecord Then
CurrentDb.Execute "UPDATE tblVehicle INNER JOIN tblStudentVehicle ON tblVehicle.VehicleName = tblStudentVehicle.VehicleName SET CheckedVehicles = [Vehicles] " _
& "WHERE StudentID=" & Me.StudentID
Me.SubFormVehicle.Requery
End If
End Sub
me.studentID is not recognized as i have underlined and marked as bold
for more information please check the db attached

 

[JHB]

Please go through my example, I don't have 2 Form_Current() procedure, (I only have one in the main form), so remove the one in the subform.

 

[Naqibullah]

oh great tnx for your valuable answer it is resolved thank you