• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 57
  • Last Modified:

avoid show empty recordsets in subforms in ms/access

Hi -
On my app I have a form with a subform.

They are (almost) right, with the exception that, when  the subform has no records at all it still shows a last record (keyed with 0) when it should show nothing.

SubForm with several records:

Screen-Shot-2018-02-11-at-09.24.05.png
Subform with NO records:

Screen-Shot-2018-02-11-at-09.24.19.png
what shall I do to avoi this?

any help appreciated
0
João serras-pereira
Asked:
João serras-pereira
1 Solution
 
MacroShadowCommented:
Set the allow additions property of the subform to false.
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.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now