How does one eliminate blank records on a query result?

[JHB]

Hi:

I have a situation where I execute a query (on part of a name) and use
the results on a form to undertake a second level of selection. This
works fine, and if there are no results I can deal with that! My
problem is that there is always a blank record that appears at the end
of the query result which shows up on the form. While this is not a
disaster, it is not the way I would like to have it work.

My question is: how does one eliminate the blank (empty) record result
on a query which has one or more legitimate records?

Thanks

John Baker

[John W. Vinson]

That's the "new record", a nonexistant record into which you can enter new
data. Depending on how this form will be used, you might want to just set the
Form's Allow Additions property to No - the new record will not be displayed
but the rest will.

Note that it is NOT necessary (or appropriate) to "run" the query prior to
opening the second form. Just open the form, it'll run the query for you.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

[JHB]

On May 22, 11:26 am, John W. Vinson
<jvinson@STOP_SPAM.WysardOfInfo.com> wrote:

Thanks.. thats what I needed

[Tony Toews]

On Tue, 22 May 2012 09:26:42 -0600, John W. Vinson
<jvinson@STOP_SPAM.WysardOfInfo.com> wrote:

>>My question is: how does one eliminate the blank (empty) record result
>>on a query which has one or more legitimate records?
>>

>That's the "new record", a nonexistant record into which you can enter new
>data.

I was quite puzzled as to what the poster meant. But now I quite
understand. Thanks for clearing that up, John.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/