limiting subform amount to amount of main form

[Guest]

i have one field in my main form called "expense limit" which holds the
maximum amount that can be paid against expenses of a patient. in my subform
i am totalling all records in one box. so i want the system to prompt me when
i enter the transaction that makes the total amount of subform to exceed the
"expense limit" entered in the main form.
is this possible.

 

[RuralGuy]

Absolutely. Here's a link to how to Refer to Form and Subform properties and
controls. http://www.mvps.org/access/forms/frm0031.htm

i have one field in my main form called "expense limit" which holds the
maximum amount that can be paid against expenses of a patient. in my subform
i am totalling all records in one box. so i want the system to prompt me when
i enter the transaction that makes the total amount of subform to exceed the
"expense limit" entered in the main form.
is this possible.

_______________________________________________
hth - RuralGuy (RG for short)
Please post to the NewsGroup so all may benefit.