Select/deselect a Yes/No control based on a date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kw_uh97 - 16 Mar 2005 18:21 GMT

How can I select/deselect a Yes/No control based on a date control on the
same form. Based on the research I've done through the discussion board. I
think the AfterUpdate procedure on the date control is where I should place
my code. If the date is 30 days passed the Current Date() the Yes/No should
be false. I would greatly appreciate the code structure to make this happen.

Thanks In Advance
kw

Reply to this Message

Jason - 16 Mar 2005 22:39 GMT

You are correct... you will want to put the code in the AfterUpdate event of
the date control. You've basically already written the code with your
explanation. Of course you will want to replace my control names with the
actual ones:

Private Sub txtDate_AfterUpdate()
If Me.txtDate < Date() - 30 Then
Me.chkYesNo = False
Else
Me.chkYesNo = True
End If
End Sub

> How can I select/deselect a Yes/No control based on a date control on the
> same form. Based on the research I've done through the discussion board. I
[quoted text clipped - 4 lines]
> Thanks In Advance
> kw

Reply to this Message

kw_uh97 - 17 Mar 2005 19:33 GMT

Jason

Works perfectly! Thanks for everything and the words of encouragement.

kw

> You are correct... you will want to put the code in the AfterUpdate event of
> the date control. You've basically already written the code with your
[quoted text clipped - 17 lines]
> > Thanks In Advance
> > kw

Reply to this Message