After Update in field on form 1

[monkeysee]

I would like to trigger an after update event to populate a field when a certain value of another field is chosen.

The choice field is a combo box. When the user chooses "Write-off" from the drop down, I would like to have the field "InsPayment" to be populated with "0". The InsPayment field is formatted as currency.

So in the AfterUpdate event procedure of the 'Write-off" field, I have the following, which I know is incomplete...and I need help in completing it

If [PaymentMethod]="write-off" then [InsPayment]= "0"

Thank you in advance for all the help anyone can give. People on this site are awesome in assisting us 'dabblers'!

 

[dhookom]

I would try code like:

If Me.[PaymentMethod]="write-off" then 
   Me.[InsPayment]= 0
End If

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[monkeysee]

Thank you Duane,
I used your suggestion, and the after update trigger did not trigger any outcome.
Are we missing something?
Thanks!

 

[dhookom]

I would place a breakpoint on the "If ..." line and hover over the PaymentMethod reference to see what the actual value might be. Can you provide the Row Source and datasheet view of the Row Source? Are you sure there isn't some type of primary key ID/code that is being used?

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[monkeysee]

Duane,
Thank you for your guidance and help! Yes there is a primary # assigned to the write-off. When I changed that in the code, it all works!

Thanks again for your generosity in sharing your knowledge!