Menu
I use a subform to show the result of a query, but at the end of record there is a *(New) for adding new records. I don't want the user to be able to add new records through this subform. How can I get rid of this?
435
Add a record to a table or form. Open the table in Datasheet View or the form in Form View. On the Home tab, in the Records group, click New, or click New (blank) record, or press Ctrl+Plus Sign (+). Find the record with an asterisk in the record selector, and enter your new information.
Modify a Subform Display the subform in Design View. Access displays the form in Design View. Click anywhere in the subform to modify it. Edit the subform as needed.
Navigate to the Table View page of your Form. Select the Record you want to delete. Click on the "Delete record" button on the Record side panel.
With the form in Design View, open its property sheet. Then select the Data tab on the property sheet, find the property named "Allow Additions" and set it to No.
80
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
