How to only view old records but and new ones?

[chang]

How can i make it that in using one form you can view old
orders "like on the northwind database" but that you can
enter new orders, but not change old orders. But in a
different form, you can edit the old records. thank you

 

[Dirk Goldgar]

How can i make it that in using one form you can view old
orders "like on the northwind database" but that you can
enter new orders, but not change old orders. But in a
different form, you can edit the old records. thank you

I haven't looked to see how it's done in the Northwind database, but you
can set the form's AllowEdits and AllowDeletions properties to No (on
the Data tab of the form's property sheet in design vew), and set the
AllowAdditions property to Yes. That will let you create new records
but not edit or delete old ones.