If today greater than Date

[Mannyf50]

Hey guys! just have a quick question for ya, im trying to set up some vba code to run an if statement comparing 2 dates i.e, if today is greater than a specified date disable these boxes, any ideas?

 

[MarkK]

You don't need IF. Enabled is a boolean property of a control and the result of your date comparison logic is also boolean. Assign the result of your logic directly to the property in question...

me.box.enabled = NOT Date() > specifieddate

Cheers,
Mark