Don't display blank or empty record

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Thanks, I'm using a form of course but this is my first time using access so
didn't know about the AllowAdditions.
 
Back
Top