Update Check Box

[jax]

I have a check box which is ticked depending on the date in another field on the form. When a date [Post_EndDate] is entered into the field the check box [Current_Past] is ticked only if the date is in the future. The problem I am having is that I want the check box to update automatically when a record is opened without having to click into the individual date field.

Any help would be appreciated.

 

[WayneRyan]

jax,

Put your code in the OnCurrent event of your form.

By the way, with these mechanics, I don't think you need
the check-box. You can calculate "what the check box means"
by running a query that compares the dates.

Wayne