Help placing code to print record based on textbox value

[Liz_I3]

I have placed the below code in the form's after update event. It works but unfortunately it triggers the print again if the navigation button ( move next or move previous) are used to view that record. Where should I be placing this code so that it will only print the record initially when it is entered.


Private Sub Form_AfterUpdate()
If Me.txtNoErrors > 0 Then
Call PrintError
End If


Thanks
L

 

[Liz_I3]

Hi Just an update I placed the same code above in the After Insert event instead of After Update and now it does only fire on the initial entry. But now where would I put the code so that it would also fire only if the record was changed. I did try it on the After Update and On Current but if would not fire . Same code but I put if me.dirty = true then......

Thanks
L

 

[xenou]

After update should work. That it fires when you use the navigation buttons suggests something in your form creates updates every time the user goes to the record (whatever the reason).

 

[stumac]

Same code but I put if me.dirty = true then

with the forms After update event the dirty property will always be false (the record is saved). You need to remove the If statement. You may also prefer to put in the before update depending on what PrintError is doing.