Suppress Autonumber record from displaying on the form

[Guest]

I have a query that feeds the form. I would like to only show the query
results without the Autonumber record showing up at the very end. Is it
possible to suppress it.

Thanks
MSA

 

[Rick Brandt]

I have a query that feeds the form. I would like to only show the
query results without the Autonumber record showing up at the very
end. Is it possible to suppress it.

Thanks
MSA

Set the Form's AllowAdditions property to No.

 

[Guest]

Just because a field is in the query, doesn't mean it must be displayed on
the form.

On the form, you can delete the control (text box) which doesn't affect the
query or data or you can set the Visible property of the text box to NO.

In the query, you could remove the autonumber field from the query grid. If
you have criteria set for the autonumber field, you can uncheck the "Show"
check box in the design grid. The results will be filtered by the criteria,
but the field won't show in the results.

HTH