Values change according to selecting value from another field

[yameen2011]

Hello friends I am working on a school database, today I am working for fee collection form and I am facing trouble.In attachment At the top right area the hidden field I would like here changes according to selecting Fee Type under Fee Detail. I want to achieve this,
If feetype is ABF then Hidden field = 1500110
If feetype is ASF then Hidden field = 1500120
If feetype is EXF then Hidden field = 1500130
If feetype is MTF then Hidden field = 1500140
If feetype is RBF then Hidden field = 1500150
How I can perform this any help would be appreciated.
Table structure is
(tblstudents) Contain students data
(tblFee) Contain, Student Id linked with student table, month, year, amount, date, narratives and FeeType that looup values from FeeType tbl, this hidden field also in tbl fee.

The codes that are 1500100,1500120,1500130
These are necessary for GL entries that’s why I must have it on my form.
I had as well apply method of Default value but in that case I only present only a single value, but I want that in hidden field values take changes according to the fee type. Kindly help me out in support of this problem.

 

[pbaldy]

One way:

http://www.baldyweb.com/Autofill.htm

 

[yameen2011]

One way:

http://www.baldyweb.com/Autofill.htm

Thank you my problem solved.

 

[pbaldy]

Happy to help.