i'm using access XP here

need help

how do i distribute a value between 2 fields or more?

say for example..

field 1 - input field
field 2 - value limit is 10, currently no value yet, or if it does have a value and still < 10(value limit) then add on top of it.
field 3 - value limit is 15, currently no value yet, or if it does have a value and still < 15(value limit) then add on top of it.
field n - value limit is n, currently no value yet,or if it does have a value and still < n(value limit) then add on top of it.

lets say i put a value into field 1, after i have inputted and lost focus of that field 1, automatically the value will spread among field 2 to field n+1. while still keeping the initial number in field 1.

eg.. i put in 12 into field 1, and automatically field 2 will become 10(thats the limit of the field value) and balance of 2 will masuk field 3, field 1 still retain value of 12 for the record.

pls advice..


========================

i was thinking of using while..do or some sort of looping to transfer one unit by one unit first while checking for conditions.. but after fulfillinf condition that how do i proceed to next array to fill it up until habis???

This post has been edited by jinaun: Feb 22 2006, 03:57 PM

i dun think so la..

nvm.. i've reclarified again in the first post.