subform in ms/access shows an empty record

Hi
On my app I have a form/subform set. They are linked and they function, with the exception that, on the subform, a blank record is always displayed as per the below screenshot


Screen-Shot-2018-03-07-at-13.51.32.png

I have changed to subform data entry property to "YES" but even though, it still shows the blank record, that should snot show
can anyone help?
João serras-pereiraAsked:
Who is Participating?
 
ste5anSenior DeveloperCommented:
Set Allow Additions of the subform to False (on the Data page in the Property Sheet).
0
 
hnasrCommented:
Yes, as ste5an commented, it's because the subform allows adding new records.

You may add a button in the main form with code, to toggle additions, like:
Me![subform_control].Form.AllowAdditions = Not (Me![subform_control].Form.AllowAdditions)

Open in new window

0
 
João serras-pereiraAuthor Commented:
Thanks!!!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.