Having 1 form field populate 2 columns in table

[Hacktastic]

Hi ,

I have this form where if someone enters a one time payment, i want it to go into the [down payment] column and also the [total payment] column for that user.

Any advice?

Thanks

 

[dhookom]

My advice is to not store the same value in two fifelds in the same table. You could have a field that identifies the payment type as "down payment" or other.

If you really want to do this, you could add code to the update of the Down Payment control to set the value of Total Payment.

    If Not IsNull(Me.txtDownPayment) Then
        Me.txtTotalPayment = Me.txtDownPayment
    End If

Again, I wouldn't do this.

Duane
Hook'D on Access
MS Access MVP

 

[Hacktastic]

Thanks Dhookom,

its a special case where its absolutely needed, a one time gift is counted as a down payment(the actual payment) and should also tally into the "total payment" which is also the total pledge