I've created a datasheet form and set the "Allow Edits" property to "No". I need to be able to past a record from excel (it has the same format and fields) into the new record row. Attached is a screenshot showing how the "paste" option is grayed out when I try to paste the record using the bar to the left of the "(New)" record cell. I'm able to paste using this method when "Allow Edits" property is set to "yes", but I still need the previously entered records to be un-editable, so I can't keep this property set to "yes".
Grayed Out "Paste" in Datasheet Form
I'm wondering if there's a way to allow me to paste using this method that keeps the previous records from being edited.
I was thinking about adding a button that enables the "Allow Edits" property, then another button that disables it, but I'm not sure how to even add a button in a datasheet form.
Any suggestions would be appreciated. Thanks!