Performing Cascading IF Else statement in Form

  • Thread starter Thread starter Wasim Yasin via AccessMonster.com
  • Start date Start date
W

Wasim Yasin via AccessMonster.com

Dear All
I need help for this. Ihave fields:Contractor name, Zone, Area, Tariff,
Rates, and No of cases. When a user enter input for No of cases then this
input multiply the 'Rates' Which depends upon The 'Tariff' and it depends
upon 'Zone' and it depends upon 'Area' and its Depends upon 'Contractor
Name'.
There r several Contractors and have several different 'Areas' belongs to
different 'Zones' and having ' three(3) types of tariff and different rates
of every tariff.
Can any one help me to develop the stratgy to caculat this?

Thanx.
 
For these situations I usually have two Private Sub/Function
* One Function which checks whether all necessary fields for the calculation
are supplied and returns True if completed
* The second Sub/Function, the Calculation Function/Sub calls the Check
function and if OK performs the calculation
In each of the fields to be used in the calc in the AfterUpdate/Lost Focus
event you call the calculation function
This way if either the final data is supplied or one of the fields is
changed the necessary calc is done.
HTH
Terry
 
Back
Top