Blank Records Retrieved on Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rillo - 15 Aug 2006 09:09 GMT

I have a query that works fine except that a blank record appears at the end
of the retrieved records. This blank record also appears on the form on which
uses the query as it's record source.

How can I stop the blank record appearing in the query and/or on the form?

Signature

Thanks in anticipation.

Reply to this Message

Svetlana - 15 Aug 2006 09:35 GMT

For the form you could set the property AllowAdditions to No.

Reply to this Message

Nick 'The database Guy' - 15 Aug 2006 09:59 GMT

Hi Rillo,

You have two options here, one of which was described by Svetlana, the
other is to set the Recordset Type in the query to Snapshot.

Good luck

Nick

> I have a query that works fine except that a blank record appears at the end
> of the retrieved records. This blank record also appears on the form on which
> uses the query as it's record source.
>
> How can I stop the blank record appearing in the query and/or on the form?

Reply to this Message