Subform creating a blank record

[Dietmar13]

Hi all,

I've got a form to create new records in a table.

First the user needs to add a product code; production line and a production version.
Second there is a subform to add actions. Step with code for that action. (example: step 1, action X11111 = apply label with machine; step 2, action X11112 = pack in box)

When the user enters date in the subform a new line blank line is created. When finished the new line is stored in the table as a blank set. Is there a way to solve this?

I've added pictures to help visualise the issue.

 

[MStef]

Yes there is a way to stop this. Make one or more fields in the table as REQUIRED.

 

[Dietmar13]

Thanks for the reply.

I've set all of them required. But then I get an error I haven't filled in a value when switching from mainform to subform.
First 5 values in the table are added in the main. Next 2 in the subform

 

[MStef]

Send a short example of your mdb, (Access 2000 or 2002-2003).

 

[Dietmar13]

I have made you a file with the form and tabel for this issue.
I had to start over cause these were linked tables, so the lay out won't be completely the same.

 

[Dietmar13]

Hi, anybody who can help me?
That would be great