Creating new record in main form from subform

[paulig2001]

Hi,

I want a user to be able to create a new record in the main form, after they have finished filling in the boxes in a subform by pressing the Enter key, rather than having to click the 'new record' button on the main form.

I reckon I need a 'default button' on the subform but I have no idea what this should do when clicked to create the new record...

 

[paulig2001]

Stupid question, have a button in the main form set as default button do the job, I assumed it wouldn't work because the focus was on the subform. I was wrong.

Rule number 1: Never make assumptions.