A
Arvi Laanemets
Hi
I have a multi-page form (fmAssets) with a subform sfTransactions based on
continous form fmTransactions on one page. All transactions have a
TransactionDate field, which is unique for given asset, i.e. only 1
transaction on given day for given asset is allowed. On form fmAsset are
some controls, which do contain the current (i.e. today's) value of some
transaction field - always the latest transaction is the valid one.
What I need, ist to recalculate those controls, whenever on subform
sfTransactions a new transaction is entered, some existing transaction is
changed, or an existing transaction is deleted. And the recalculation must
occur after:
1. a new record on fmAssets is selected (from record selector or by
shortcut)
2. Another page of fmAssets is activated
3. Another control on fmAsset is selected (Here at moment I use subform's
OnExit Event)
4. The application is closed.
The actions the Events have to run are:
1. Saving the record in fmTransactions, whenever there was some unsaved
change - except a new record was created but all controls remained empty
(probably I'll disable all controls there except TransactionDate, whenever a
new record is selected, and I'll enable them only, when TransactionDate
isn't empty)
2. Saving previous current values on fmAssets to variables.
3. Calculating new current values to variables.
4. Replacing on fmAssets old values of controls with new ones, whenever at
least one of them changed.
5. Saving the record in fmAssets, whenever old values were replaced.
6. Refreshing some other controls on fmAssets, whenever old values were
replaced.
Somehow I'm at some dead point here, and can not decide, which Events are
best to use, and which actions where to run. Can someone give me some
advice?
Thanks in advance!
Arvi Laanemets
I have a multi-page form (fmAssets) with a subform sfTransactions based on
continous form fmTransactions on one page. All transactions have a
TransactionDate field, which is unique for given asset, i.e. only 1
transaction on given day for given asset is allowed. On form fmAsset are
some controls, which do contain the current (i.e. today's) value of some
transaction field - always the latest transaction is the valid one.
What I need, ist to recalculate those controls, whenever on subform
sfTransactions a new transaction is entered, some existing transaction is
changed, or an existing transaction is deleted. And the recalculation must
occur after:
1. a new record on fmAssets is selected (from record selector or by
shortcut)
2. Another page of fmAssets is activated
3. Another control on fmAsset is selected (Here at moment I use subform's
OnExit Event)
4. The application is closed.
The actions the Events have to run are:
1. Saving the record in fmTransactions, whenever there was some unsaved
change - except a new record was created but all controls remained empty
(probably I'll disable all controls there except TransactionDate, whenever a
new record is selected, and I'll enable them only, when TransactionDate
isn't empty)
2. Saving previous current values on fmAssets to variables.
3. Calculating new current values to variables.
4. Replacing on fmAssets old values of controls with new ones, whenever at
least one of them changed.
5. Saving the record in fmAssets, whenever old values were replaced.
6. Refreshing some other controls on fmAssets, whenever old values were
replaced.
Somehow I'm at some dead point here, and can not decide, which Events are
best to use, and which actions where to run. Can someone give me some
advice?
Thanks in advance!
Arvi Laanemets