How does one eliminate blank records on a query result?


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
 
Ad

Advertisements

J

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
 
J

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
 
Ad

Advertisements

T

Tony Toews


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top