Go to New Record on Datasheet form

[gstylianou]

Hello my friends,

I have the following problem:
Attached you can find my example database which includes one main form (MAIN) in which there is another one subform (Subform). The subform (with name: Subform) takes data from one table and includes as you will see, the subData subform in Datasheet format.

What I'm trying to achieve (without any result) is when I press the command button that exist into Subform, i want to go to a new record in Datasheet form but .... ATTENTION: New Record as the same record ID (ex, 28). Unfortunately, though I tried several, unfortunately, I failed.

I will appreciate your help

 

[arnelgp]

try this one

 

[gstylianou]

try this one

thank you very much, working fine.

thanks