Help

[t406jaw]

Help!

I have 3 text boxes on a form in access,

Total Training Sessions 35
Traing Sessions Attended any number (say 20)
Training Sessions missed
Letter (check box)



is it possible with the use of code for the 3 text box to work out the number of sessions missed ie 15 and add a check in the box if the number of sessions missed is greater than ten.??????????

 

[bat17]

On the On Current event of the form you want something like:-

If Me![Total Training Sessions] - Me![Training Sessions Attended] > 10 Then
   Me![Letter].Visible = True
Else
   Me![Letter].Visible = False
End If

HTH

Peter

 

[Tanis]

In the After Update event procedure for the text box Training Sessions Attended, put something like this.

Me.[TrainingSessionsMissed] = Me.[TotalTrainingSessions] - Me.[TrainingSessionsAttended]

If Me.TrainingSessionsMissed > 10 Then
Me.Letter.Visible = True
' or Me.Letter = true
End If

You will need to set the checkbox property Visible to No and set the Default Value to True. It might be better to have the check box visible but set to false and update it to true when the test has been passed. Just a thought.

 

[t406jaw]

anyone else got any idea how to do this

 

[bat17]

Whats wrong with the two answers you have had already?

Peter

 

[t406jaw]

they dont appear to work

 

[n107jkx]

I like your style T406JAW !!