Don't display blank or empty record

[Guest]

Hi,

I have a query which works fine and displays results "tabular". I'd like to
not display the blank empty record at the end of the results set.

Thanks in advance for any help.

 

[Ken Snell [MVP]]

All updatable queries will show the "blank" record at the end as this is how
a new record can be added. You shouldn't show a query directly to a user --
instead, use a form to display the query's results, and then you can set the
AllowAdditions property of the form to No, which will prevent the display of
that "new record" record.

 

[Guest]

Thanks, I'm using a form of course but this is my first time using access so
didn't know about the AllowAdditions.