Problem with SubForm - record selector always jumps to first record

[bdg4820]

In the zip-file attached below is my "problem" database. (to see the problem open frmLedenArtikels)
On top of the form just select a name from the combo box, the subform then lists the items that person has bought on a certain date. So very easy form.

The problem is the following. When I try to add items to the subform, the record selector in the subform always automatically jumps back to the first record in the subform. this is very annoying and I have totally no clue why this is happening.

 

[Pat Hartman]

I didn't look at the database but I would guess that your code includes a requery. It is unlikely that the requery is necessary and it might be that you are actually trying to save a record and should be doing that rather than requerying.

DoCmd.RunCmd acCmdSaveRecord

 

[bdg4820]

Problem solved

I found the solution, just re-insert the subform again using the wizard. That seems to magically solve the problem. Thanks for the requery tip anyhow.