Subform update issue

[RayMilhon]

I have a main form That saves member demographic information. Then I have a subform that allows the user to enter comments specific to that member. It's a one to many relationship. The issue I'm having is that when one user enters a comment (Fields displayed are comment date and comment text Multiple comments for the same day are allowed) After the record is input the info that was typed in disappears and another comment is displayed. If the member record is changed and then changed back the comment that was displayed is gone and the comment that had been typed in is displayed. I have a temporary fix in that the after update event requeries the data and refreshes. The form this is a temporary fix since when the Requery occurs the focus is set back on the first comment record. This is not a permanent fix because eventually some of these records could have upwards of 30 comments. The user would then have to scroll through all 30. Anyone have an idea how I can resolve this?



Thanks

[pbaldy]

Is this appropriate?

http://www.baldyweb.com/Requery.htm

or using

DoCmd.GoToRecord

specifying the last record?

[RayMilhon]

Thanks Paul that did the trick

Added

Me.Requery
DoCmd.GotoRecord , , acNewRec

To the After update event of the form and everything works just like it should. Thanks again.

[pbaldy]

Happy to help!