A
Ammo
Hi,
I have created a main grants form called 'frm_GrantPot' that consists of a
sub form in datasheet view with several fields. The most valid fields in the
subform for this problem include:
AmountGrantAllocated, GrantSpentToDate, AllocatedGrantRemaining
What I wish to achieve is for the user to be able to key a figure under the
'AmountGrantAllocated' field and also be able to key a figure in the
'GrantSpentToDate' field without exceeding the corresponding
'AmountGrantAllocated' value keyed in originally for the record. I then would
like a figure to automatically appear under the 'AllocatedGrantRemaining'
field, which is the difference between the 'AmountGrantAllocated' and
'GrantSpentToDate' field values.
For example: AmountGrantAllocated (£1500), GrantSpentToDate (£200),
AllocatedGrantRemaining (£1300)
Hope somebody can help! Thank you!
Ammo
I have created a main grants form called 'frm_GrantPot' that consists of a
sub form in datasheet view with several fields. The most valid fields in the
subform for this problem include:
AmountGrantAllocated, GrantSpentToDate, AllocatedGrantRemaining
What I wish to achieve is for the user to be able to key a figure under the
'AmountGrantAllocated' field and also be able to key a figure in the
'GrantSpentToDate' field without exceeding the corresponding
'AmountGrantAllocated' value keyed in originally for the record. I then would
like a figure to automatically appear under the 'AllocatedGrantRemaining'
field, which is the difference between the 'AmountGrantAllocated' and
'GrantSpentToDate' field values.
For example: AmountGrantAllocated (£1500), GrantSpentToDate (£200),
AllocatedGrantRemaining (£1300)
Hope somebody can help! Thank you!
Ammo