auto distribute figures into form

[AOGFADUGBA]

Hi Again,
am trying to distribute an amount into several field in a form at once. is there a way to go about it.
This is the senerio. i have a form bound to a table with 55 fields all currency/number fields and i want to create a unbound text box to input the lumpsum amount into and it will distribute it based on percentage into the 55 fields on the form. is it possible?
thanks

 

[AOGFADUGBA]

Hi All I finally got the populate action running thanks a lot. i used the append query and its fully functional.