SubForm

[Muppetnation]

Hi,

I am trying to design a subform to allow multiple records to be entered and then uploaded to a table. I've designed the subform but it is currently pulling all of the records from the table through and all I want is a blank subform for data entry.

I have tried putting a macro in the On Load and On Open events to get it to go to a new record but I keep getting error number 2046. Can anyone help please?

 

[CJ_London]

just set the form dataentry property to yes

 

[KenHigg]

I think you can set the form to allow additions only in form properties