Unbound checkbox's that update

[Madmax]

Good Afternoon,

Is there a way to setup checkbox's that are unbound but update based off whether a field has a date in it or not? The idea is it auto updates a checklist on the right that shows the correct order to do something but the left where the date is at is split up by who's responsible to do what. Just want to show a check mark if there is a date in the field. If the field is null then the check box is unmarked. Auto both ways soon as the field updates. Thoughts on how to do this?

[ketbdnetbp]

If using this just for a form, you could try...

If IsDate(Me![DateField]) =True then
Me![CheckBoxName]=-1
else
Me![CheckBoxName]= 0
end if

You may need to put this code into the AfterUpdate Event of the date field and the Current Event of the form. You would need to use the Current Event because of the unbound nature of the control.

All the best,

Jim

[Madmax]

You said it had to be put in the current event for the form. What if I am going to use this more than once for different date fields and check marks. Will I have to put each of them in the current event for the form for each check mark as well as the update on the field for each field? I dont mind just dont want to mess it up

[June7]

The Current event code is to correctly set the controls when you first move to a record. If you do anything on the form, such as data entry, that influences the settings, would need code in the AfterUpdate event of the triggering control.

[ketbdnetbp]

As June7 indicated, the current event fires when you first navigate to a particular record and the afterupdate event fires when data is changed/added to a control at form level. So, unfortunately, you would have to add code for each control where you want this behavior to occur.

So, how many controls are you talking about? Depending on that number, a different logic structure might also be needed.

Let me know...

Jim

[Madmax]

Between 5 and 15 for different forms. Idea is to give a visual representation that its complete without actually bothering with storing useless data for my officers.