Check box in a form

[ariansman]

I have made an unbound check box, named “myckeck” in a form which shows data from a table in tabular layout.
1- When I check one check box, all check boxes are checked. How can I solve that? I mean I want to check or clear check boxes independently.
2- I made a text box, named “jobdate” to sow todays date automatically upon checking a check box. I made this code:

Private sub mycheck_afterupdate()
jobdate = date
End

But this is not working and checking a check box does not make anything to happen.
3- Then I made this expression in the default value of “jobdate” properties:
iif( mycheck = true, date(), null)
This not working either.

Thank you

 

[catalin.petrut]

1. You cand check or uncheck the box independently because the checkbox is unbound control!
2 & 3 will may be resolved only after resolving no 1.

 

[ariansman]

i made a field in the original table, and bound the check box to it. now they can be checked in dependently. When i check one of them, the above code is run, but all the [jobdate] records are filed at the same time. Is this because the form is in tabular layout?

 

[catalin.petrut]

Same problem! The unbound fields will act like this in a form. You will have to bound the field to a table field.