N
NevilleT
I have
- A datasheet which has budget and expenditure by account code
- A sub datasheet where you can see and enter expenditure items.
The main datasheet shows summary information from the sub datasheet such as
total expenditure. This comes from a query which uses a sum to total
expenditure by account.
What I want to do is:
- Enter an expense item in the sub datasheet
- Exit the sub datasheet which would save the expenditure item
- Update the main datasheet with the new expenditure total.
The problem
I can use the AfterUpdate event on the subform to do a recalc on the main
datasheet (Forms!frmExpenditure.Recalc) and it works except for one
irritating thing. If you click on the minus button to roll up the sub
datasheet, the form recalcs and you have to click it again to close the sub
datasheet. Certainly not a show stopper but it would be nice if I could
have it run AFTER the sub datasheet is rolled up. I have tried OnCurrent and
OnActivate but neither seem to work.
- A datasheet which has budget and expenditure by account code
- A sub datasheet where you can see and enter expenditure items.
The main datasheet shows summary information from the sub datasheet such as
total expenditure. This comes from a query which uses a sum to total
expenditure by account.
What I want to do is:
- Enter an expense item in the sub datasheet
- Exit the sub datasheet which would save the expenditure item
- Update the main datasheet with the new expenditure total.
The problem
I can use the AfterUpdate event on the subform to do a recalc on the main
datasheet (Forms!frmExpenditure.Recalc) and it works except for one
irritating thing. If you click on the minus button to roll up the sub
datasheet, the form recalcs and you have to click it again to close the sub
datasheet. Certainly not a show stopper but it would be nice if I could
have it run AFTER the sub datasheet is rolled up. I have tried OnCurrent and
OnActivate but neither seem to work.