quick question

[Nicolette]

Can I set the default value of a textbox on a subform to the calculated total on another subform?

I calculate the total of an order in one subform
another subform allows me to record a payment
can i have the default value of the PaymentAmount Textbox be the total calculated?

I tried
=[frmRecordPaymentSUB1]![Ordertotal]

 

[PNGBill]

You can have an unbound text box control on one subform that shows that value of a text box control on another subform on the same mainform.

Or, you can have an unbound... on your subform thatuses an expression to get the same value. ie, just do the calculations again.

Right syntax? I will have to scratch my head and get back to, unless another does so but...
I consider, rather then have the amount as the Default, have a warning or another box that holds the amount and a warning where the two are not the same.

You enter the repayment and this is matched against the text box or just the amount(it calculates) and produces a warning.

This way, you try and avoid hitting the enter key and later finding out the repayment wasn't the exact amount.
Be careful of having the Correct Amount as Default Value.

 

[Galaxiom]

You must refer to the Form property of the subformcontrol rather than directly the form object which Source Object of the subformcontrol.

= Forms!mainformname!subformcontrolname.Form!controlname