Luc: Just locate a Variable Label field on your form and assign it to "vpricetopay". After calling your stored procedure, do a "recalc var" to force the field to reevaluate on your form.
Karen > On a form I have multipele currency fields. > > Via a stored procedure I calculate the sum of certain fields (which > varies) and want to display the result of my stored procedure in a variable > (or > other?) field on the form. > > In access you can set the source/value property of a variable to " > =Procedure()". > > In rbase I have a stored procedure that calculates the variable > "vpricetopay". > How can I set a variable to display this result dynamically on my form > without saving the value to a table ? > > Tx > > Luc Delcoigne >
