Hey People,
I am getting an Error 'You can't assign a value to this object.' when i am trying to update a text box value that has Control Source that is placed on a other form
Please guide me on the same
I am getting an Error 'You can't assign a value to this object.' when i am trying to update a text box value that has Control Source that is placed on a other form
Please guide me on the same
Code:
If RVCalcCheck Then Me.ContractRemainingRV.Value = mdblOriginalRV - (Access.Nz(Me.txtRVTransfer.Value, 0#) + Access.Nz(Me.txtRVRecovery.Value, 0#)) 'Me.ContractRemainingRV.Value = mdblOriginalRV - Access.Nz(Me.txtRVTransfer.Value, 0#) 'Me.ContractRemainingRV.Value = mdblOriginalRV - (Access.Nz(Me.txtRVRecovery.Value, 0#)) Me.txtContractRemainingRV.Requery 'DoCmd.RunCommand acCmdSaveRecord Else MsgBox "Remaining RV cannot be less than zero", vbExclamation, "RIMS" 'Me.txtRVTransfer.Value = Me.txtRVTransfer.OldValue End If If Me.[ContractRemainingRV] - (Me.txtRVTransfer - Me.txtRVTransfer.OldValue) - Me.txtRVRecovery < 0 Then MsgBox "Remaining Rv cannot be less than zero!", vbCritical, "RIMS" Me.txtRVTransfer = Me.txtRVTransfer.OldValue Else Me.ContractRemainingRV = Me.ContractRemainingRV - (Me.txtRVTransfer - Me.txtRVTransfer.OldValue) End If Me.txtContractRemainingRV.Requery 'DoCmd.RunCommand acCmdSaveRecord Forms!frmContractRewrite!txtRemainingRV.Value = val(Me.txtRVTransfer.Value) + Forms!frmContractRewrite!txtOldPVofRV.Value Forms!frmContractRewrite!txtRemainingRV.Requery strRewriteContractNOValue = ""
Comment