Blank Records Retrieved on Query

R

Rillo

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?
 
N

Nick 'The database Guy'

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
 
Top