How does one eliminate blank records on a query result?

  • Thread starter Thread starter JHB
  • Start date Start date
J

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
 
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
Click to expand...

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
 
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
Click to expand...

Thanks.. thats what I needed
 
Back
Top