Jonny45wakey
Member
- Local time
- Today, 02:38
- Joined
- May 4, 2020
- Messages
- 40
Hi I have a form called frmMasterData which contains the following code in the On Timer Event:-
Private Sub Form_Timer()
Me.Text33.Requery
If Me.Skill_Renewal_Date.Value >= Text33.Value Then
Me.Training_Status.Value = "In-Date"
Else
Me.Training_Status.Value = "Expired"
End If
End Sub
The Textbox called "Text33" contains the function =Now()
I want the form to loop through each record and compare the "Skill_Renewal_Date" value against "Text33" value and then update
"Training_Status" value accordingly as above.
i would like this to perform on the OnOpen Event of the form.
Any help much appreciated
Regards
Jonny
Private Sub Form_Timer()
Me.Text33.Requery
If Me.Skill_Renewal_Date.Value >= Text33.Value Then
Me.Training_Status.Value = "In-Date"
Else
Me.Training_Status.Value = "Expired"
End If
End Sub
The Textbox called "Text33" contains the function =Now()
I want the form to loop through each record and compare the "Skill_Renewal_Date" value against "Text33" value and then update
"Training_Status" value accordingly as above.
i would like this to perform on the OnOpen Event of the form.
Any help much appreciated
Regards
Jonny