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]

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

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]

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 setthe
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 alsohttp://www.utteraccess.com

Thanks.. thats what I needed

 

[Tony Toews]

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/