Requery and move to last record on a subform

[Kan09]

i'm having a problem with the requery and move to last command on some subforms.

The subforms are used to view the data enterd into the table. I have 3 forms that use subforms. On 2 of the subforms the requery is made and the data can be seen on the subform ,but the subform does not go to the las record enterd, the user having to search for it.The data seems to updated by user...but there is no ordery by statement.
On one form the requery + go to last record works fine. The code is practically the same...so why does it not work?

here is the general code:

Private Sub Form_AfterInsert()
Me![CustomerSupportActivityBranch subform].Requery
Me.[CustomerSupportActivityBranch subform].Form.RecordsetClone.MoveLast
Me.[CustomerSupportActivityBranch subform].Form.Bookmark = Me.[CustomerSupportActivityBranch subform].Form.RecordsetClone.Bookmark
End Sub
 

Thank you

[NeoPa]

I doubt if anyone can tell you without seeing it. You tell us there are three subforms and that one is different from the other two. You don't tell us, and we have no way of finding out for ourselves, what is different in the design of any of these forms. I can't see a way we can answer your question. Sorry.

[Kan09]

I solved the problem by recreating the two subforms. The problem was probably something from A2000...because the subforms were built in A2000 and i'm working on 2003.

Thanx

[NeoPa]

That's good news. I'm glad you solved (and posted it) your problem.