Form refresh After Update

[yippie_ky_yay]

Hello all,

I've made it so that my form refreshes after any updates to any of the records on my continuous form occur. This works fine, but it was a pain to put in an after_update event for each field. Could I not have done just one?
ie
Private Sub current_record_after_update()
me.Refresh
end sub
would've been nice!

Thanks!

-Sean

 

[ghudson]

Try the "forms" after update event.

Private Sub Form_AfterUpdate()
Me.Refresh
End Sub

HTH

 

[yippie_ky_yay]

Thanks for answering ghudson,

I did try that, and it kind of worked. My subform is a continuous form, so it does refresh if I click on another record - but not if I just change fields.

-Sean

 

[ghudson]

Making changes to a field is not going to "write" those changes until the record has been saved. Moving to another record is one way to save a record. You could give the users a "save" button if you want them to control when the changes are saved if they do not actually move to another record and/or close the form. It is good practice to give your users that type of control. Notifying them that a change has been made and do they want to save the changes to the current record can be caught in the forms BeforeUpdate event.