Unbound field, calculating field....manual input ????

[Lanie]

Okay, so now my customer wants to be able to key in an amount in this unbound, calculating field. <br><br>I've set him up so that he enteres the amount and a percentage and the unbound field calculates and holds the results.&nbsp;&nbsp;But, now he wants to be able to override the calculation with his own amount.&nbsp;&nbsp;I suggested that he figure out what the percentage is and key that in, but he feels that takes too much time.<br><br>I've tried the properties but can't find anyplace that allowes this to be updated or something like allow manual inputs as well.&nbsp;&nbsp;<br><br>Does anyone know how to get around this?&nbsp;&nbsp;Thanks again for all you help.&nbsp;&nbsp;Lanie <p>Lanie<br><a href=mailto:etroidl@conaxfl.com>etroidl@conaxfl.com</a><br><a href= > </a><br>

 

[rhicks]

If you are doing what I think, you are using the control source to the produce the result. This way bounds the result to the calculation, and you can't overwrite it. What I suggest is to use the After Update events of both amount and percentage to populate the result. This way you could overwrite the result. An example would be:<br><br>Private Sub YourAmount_AfterUpdate()<br>If IsNull(Me![YourAmount]) Or IsNull(Me![YourPercentage]) Then<br>Exit Sub<br>End If<br>Me![YourResult]= 'Place you calulation here<br>End Sub<br><br>Place the same code in the After Update event of YourPercentage.<br>Of course the names of the control need to be changed to the actual names of your controls.<br><br>Good Luck,<br>RDH<br><br> <p>Ricky Hicks<br><a href=mailto: rdhicks@mindspring.com> rdhicks@mindspring.com</a><br><a href= > </a><br>