blank row in table

[kyle12345]

I have a query that populates a table. This table will have 1 row of data.
I then have a form that looks at this table. When the table is populated,
the table populates with one row of data, but then i get a second row that is
completely blank and on the side of the row I get a "*". You see this when
you actually view the table. When I view the results from the query, I do
not get this second blank row. So my problem is when I am viewing that table
from the form, I initially can see all my populated data in row 1, but if I
use the scroll button on my mouse, the form looks at that second row that is
blank (the one with the "*" in the table).

How can I remove that second row in the table that is blank? or how can I
make sure when the user uses the scroll on their mouse it does not view the
blank row in the form? Creating a second query to delete null rows does not
solve my problem.

 

[Keven Denen]

I have a query that populates a table.  This table will have 1 row of data.  
I then have a form that looks at this table.  When the table is populated,
the table populates with one row of data, but then i get a second row that is
completely blank and on the side of the row I get a "*".  You see this when
you actually view the table.  When I view the results from the query, Ido
not get this second blank row.  So my problem is when I am viewing thattable
from the form, I initially can see all my populated data in row 1, but ifI
use the scroll button on my mouse, the form looks at that second row thatis
blank (the one with the "*" in the table).  

How can I remove that second row in the table that is blank?  or how can I
make sure when the user uses the scroll on their mouse it does not view the
blank row in the form?  Creating a second query to delete null rows does not
solve my problem.

The blank row that you are seeing with the * next to it isn't actually
in the table. It's just a row where you can add a new data record into
the table. This will never go away when viewing the table.

If you want to make it so the user can't add new records on the form
(which will make the blank row with the * go away), go to the form
properties and on the data tab, change Allow Additions to No.

Keven Denen

 

[kyle12345]

that worked. thanks

The blank row that you are seeing with the * next to it isn't actually
in the table. It's just a row where you can add a new data record into
the table. This will never go away when viewing the table.

If you want to make it so the user can't add new records on the form
(which will make the blank row with the * go away), go to the form
properties and on the data tab, change Allow Additions to No.

Keven Denen