Auto check mark based on criteria

[ILoveAccess via AccessMonster.com]

My form is set up as following:

frmLeads (MainForm)
DateEntered (autodate)
RBMDateRtrnd (date)
RBMOnTime (checkbox)
DistribDateRtrnd (date)
DistribOnTime (checkbox)

How do I make the following work:

I enter a date into "RBMDateRtrnd"---- if the date is within 14 days of the
"DateEntered", then the checkbox called "RBMOnTime" automatically checks.

Same thing with DistribDateRtrnd, DistribOnTime, and "DateEntered"

Thanks!

 

[fredg]

My form is set up as following:

frmLeads (MainForm)
DateEntered (autodate)
RBMDateRtrnd (date)
RBMOnTime (checkbox)
DistribDateRtrnd (date)
DistribOnTime (checkbox)

How do I make the following work:

I enter a date into "RBMDateRtrnd"---- if the date is within 14 days of the
"DateEntered", then the checkbox called "RBMOnTime" automatically checks.

Same thing with DistribDateRtrnd, DistribOnTime, and "DateEntered"

Thanks!

code the [RBMDateRtrnd] AfterUpdate event:

[RBMOnTime] = DateDiff("d",[RBMDateRtrnd],[DateEntered])<=14

[DistribOnTime] = DateDiff("d",[DistribDateRtrnd],[DateEntered]) <=14

Depending upon your date entry, you may have to switch the positions
of [RBMDateRtrnd] and [DateEntered]
You want the earlier date before the later date.