Viewing Queried Form

[Ktowner]

I have a large form that is controlled by a query that asked for an equipment
number. When the form opens to the equipment record and you scroll down to
see all fields there is a second blank form as well. How can I get only the
queried equipment record to show when scrolling down?

Access 07

Thank You

Don K.

 

[Al Campagna]

Ktowner,
Sounds like you have the form's Form View set to Continuous instead of
Single Form.
The blank record your seeing is the "New" record at the very end of that
continuous "updateable" recordset.

If you set your form to Single you won't be able to "scroll" to the
"New"
blank record, but you will still be able to PageDown to it... as with any
Single
recordset.
If you want to get rid of the blank record in both instances, set the
form's
Allow Additions to False.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."