Auto check mark based on criteria

  • Thread starter Thread starter ILoveAccess via AccessMonster.com
  • Start date Start date
I

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!
 
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!
Click to expand...

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.
 
Back
Top