Why is text box not updating?

[Buakaw]

I have a form named frmPaymentDetails.

I have the following controls on this form:
[DefaultFees] - Text box. Control source is taken from a field in a Table.

[AmountPaid] - Unbound text box control.

Problem:
I update the value in DefaultFees by manually typing a new value in the text box. And then I hit a button which calls a subroutine.



Private Sub DefaultFeeUpdateButton_Click()
' Refresh the [Amount Paid] text box
Me.AmountPaid.Value = Me.DefaultFees.Value
Me.AmountPaid.Requery
End Sub

However, inside the subroutine, Me.DefaultFees.Value shows the old value, which I've already overwritten in the text box manually. It is not reading in the new value which I typed.

What is the problem?

Thanks.

[RuralGuy]

Have you tried putting your code in the AfterUpdate event of the DefaultFees control?

[Buakaw]

Have you tried putting your code in the AfterUpdate event of the DefaultFees control?

Hi RuralGuy
I'll give it a try. Thanks.

But if anyone else has an idea to make the button work, I'll appreciate it. It more closely meets the needs of the user.

[pkstormy]

You may also need a Refresh command after updating the value. This will refresh the form.

[Buakaw]

You may also need a Refresh command after updating the value. This will refresh the form.

Bingo! It works exactly as expected now! Thanks!