I am trying to SetProperty Value of a field in a table with the current value of a temporary variable.
I am using a Macro to do this. My CUSTOMER table has a 'General Number with 3 decimals' field defined as ProRate.
I have a calculated 'temporary variable' named tmpProRateAmount. I use a 'message box' to display the result and in this particular case the result is .08 . This is correct and I now want to move this value into my table.
So I SetProperty of ProRate with the Value =[TempVars]![tmpProRateAmount]
Problem: The value that shows in the CUSTOMER table is 0
I am not sure what I am doing wrong. Any thoughts?