Now I am confused. If the extra fields are not part of the query, which
query are you talking about? I still don't understand why you can't just
delete the extra fields from the form or make them invisible.

Signature
Dave Hargis, Microsoft Access MVP
> Now I am confused. If the extra fields are not part of the query, which
> query are you talking about? I still don't understand why you can't just
[quoted text clipped - 87 lines]
>
> - Show quoted text -
There is one query that is used to populate a continuous form. If I
run the query by itself it returns just just the data expected. When I
open the continuous form, the query is run and the form is populated.
The issue is if the query returns 5 lines of data, when the form is
open the 5 lines of data are displayed with the two fields that can be
edited in the form, plus there is another line of no data but this
line has the editable fields.
Example: The two editable fields are Filled Qty and Filled By
Query Results:
Part Number Description Order Qty Filled Qty Filled By
123456789 Part 1 1 ________ _______
ABDFEFG Part 2 2 ________ _______
123ABC1 Part 3 1 ________ _______
98765432 Part 4 3 ________ _______
ZXDER33 Part 5 5 ________ _______
Form Results:
Part Number Description Order Qty Filled Qty Filled By
123456789 Part 1 1 ________ _______
ABDFEFG Part 2 2 ________ _______
123ABC1 Part 3 1 ________ _______
98765432 Part 4 3 ________ _______
ZXDER33 Part 5 5 ________ _______
________
_______
I would like to get rid of the two extra lines in the form. If I
change the Visable setting on the Filled Qty and Filled By to No then
none of those fields will be displayed.
Douglas J. Steele - 11 May 2007 01:54 GMT
Sounds as though the blank line is there to let you add new records. Simply
set the form's AllowAdditions property to False.

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
On May 10, 7:58 am, Klatuu <Kla...@discussions.microsoft.com> wrote:
> Now I am confused. If the extra fields are not part of the query, which
> query are you talking about? I still don't understand why you can't just
[quoted text clipped - 99 lines]
>
> - Show quoted text -
There is one query that is used to populate a continuous form. If I
run the query by itself it returns just just the data expected. When I
open the continuous form, the query is run and the form is populated.
The issue is if the query returns 5 lines of data, when the form is
open the 5 lines of data are displayed with the two fields that can be
edited in the form, plus there is another line of no data but this
line has the editable fields.
Example: The two editable fields are Filled Qty and Filled By
Query Results:
Part Number Description Order Qty Filled Qty Filled By
123456789 Part 1 1 ________ _______
ABDFEFG Part 2 2 ________ _______
123ABC1 Part 3 1 ________ _______
98765432 Part 4 3 ________ _______
ZXDER33 Part 5 5 ________ _______
Form Results:
Part Number Description Order Qty Filled Qty Filled By
123456789 Part 1 1 ________ _______
ABDFEFG Part 2 2 ________ _______
123ABC1 Part 3 1 ________ _______
98765432 Part 4 3 ________ _______
ZXDER33 Part 5 5 ________ _______
________
_______
I would like to get rid of the two extra lines in the form. If I
change the Visable setting on the Filled Qty and Filled By to No then
none of those fields will be displayed.