Subform data entry problem when adding a new record

[Urco]

Hi,

Since recently I have an issue when adding a new record. I have a main form with two subforms on it. When I enter the data in the main forms' fields everything is alright. When I want to enter data in any of the subforms, on entry it first skips to a different record. This is always the same record a couple of thousand records back. Then you have to go back to the latest record and only then you can enter data in the subforms.

What can be done about this? Or do you know what causes this strange behavior?

 

[MStef]

In Sub from_Load put the code:

DoCmd.GoToRecord, , acNewRec

 

[Urco]

Thanks for the advice. I tried it immediately.
However, the problem stays there.

So I add a new record and everythink works fine until you click in one of the subforms. It then jumps to an old record, always the same one. When you go back to the new record you can add data in the subform, but only then.

Very strange, anymore ideas?