Query results allowing new record?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I get query to stop allowing new records off of a query from a table?
The query should only pull up the requested records.
I am getting a row with a * at the bottom of the query. How can I get this
to stop?
Thanks.
 
If the query is updatable, and you're viewing the query directly, you cannot
stop the extra row.

But, one should not be viewing query results directly anyway. Use a form to
display the results, and then set the form's AllowAdditions property to No.
 
How do I get query to stop allowing new records off of a query from a table?
The query should only pull up the requested records.
I am getting a row with a * at the bottom of the query. How can I get this
to stop?
Thanks.
Click to expand...

First off... don't use query datasheets for data display or editing;
use a Form instead. You can set the Allow Additions property of a Form
to false.

To do so in a Query, you can make the query non-editable entirely
(can't add new or change existing) by changing the Recordset Type
property of the query (in the Properties view) to Snapshot.

AFAIK there's no way to set a Query to allow edits but to forbid
additions.

John W. Vinson[MVP]
 
To both responses above. I tried the form thing and it does not work. It
still allows the addition of a new record. That is why I asked about the
query. I tried it again this morning and it still allows a new record.
 
Believe me, if you set the AllowAdditions property of the form to No, it
will not allow you to add new records. Retrace the steps that you did and
ensure that all were performed as posted.
 
Back
Top