Any ideas about how can I do this?

[dinosaur]

Hi everybody,
I'm new at here so excuse my ignorance.
And also I'm portuguese so excuse my bad language.

I've a problem here.
In the database below there are a form called "Sessões por Casa" wich as two subforms.
In the left are shown records from the table "records". And in the right is a subform wich groups the records from the left subform by date.

What I need to do is: When I click the "Pago" checkbox in the right subform I need it to check all the checkboxes with the same date in the left subform.

Can anybody please help me?

Database :: http://www.danielmartins.com/gestao.zip

 

[dinosaur]

please... anyone?

 

[miltiadis21]

Database asks for password

 

[dinosaur]

Ooo, sorry the passwor is "xixo"

 

[dinosaur]

Ok, I've solved the previous problem with an update query.
But I still have a lot of unsolved problems.
- In the right subform (detailshow) there are a column called "Em débito". I want it to display the "ValorR" sum of all records in the "Records" table till the date of the current row. Any ideas?

Please help me, because I still have a lot of things to do, and I need this to be done Tomorrow...

 

[Rabbie]

Ok, I've solved the previous problem with an update query.
But I still have a lot of unsolved problems.
- In the right subform (detailshow) there are a column called "Em débito". I want it to display the "ValorR" sum of all records in the "Records" table till the date of the current row. Any ideas?

Please help me, because I still have a lot of things to do, and I need this to be done Tomorrow...

You could use DSUM for this using <= [DateofCurrent record] in the criteria. See Access Help for more info on DSUM

 

[dinosaur]

I've already tried to use dsum with the criteria you mentioned but it still not work.

 

[Rabbie]

Try this link for more info that may help you.