Subform check

[yessir]

I need this in 3 hours?!?!?!?

I have this db (just a section is included) in which I have a form with a sub form to display the childs name and the subfor to display the childs point record based on a cbobox of child names.

Ther is also a check box, and i NEED it so that when the checkbox is checked, all the tbl_points.active = -1 (true) between #2003/09/11# and Now()

I have tried this for a while, can someone help?

 

[mark curtis]

look at the attached.

put some dates in and change the combo!

 

[yessir]

thanks for the quick reply, but that doesn't work properly...

1) the begin date is static, as above post

2) it throws an error on click of the use points check

3) I do not want to have to enter dates, just between #2003/09/11# and Now()

could it just be a button (easier?)

~Thanks Though!
~Still

 

[yessir]

PLZ PLZ PLZ

Could Someone please look at this,

I need to be able to do it by 3 hours from now!

I REALLY NEED HELP!

~

 

[RayH]

Probably too late for you but :

Private Sub Check12_AfterUpdate()
DoCmd.SetWarnings False

If Check12.Value = True Then DoCmd.OpenQuery ("UpdatePoints")
DoCmd.SetWarnings True
Me.Refresh
Me.Check12.Value = False

end sub



Query called "UpdatePoints"
UPDATE tbl_points SET tbl_points.active = True
WHERE (((tbl_points.ChildID)=[Forms]![tbl_children]![Combo10]) AND ((tbl_points.DateTest)>=#9/11/2003#));

 

[yessir]

You know what, that was amazing, and i have to thank you for that, i tried but i can't get my head to un-stick once i think it should work 1 way!

THANK YOU

~