Form in Datasheet View preventing deleting of record

[SoxPats83]

i have a form being used as a sub form that is in datasheet view. it basically looks as if i have a table as my sub form. it is exactly what i want, except for one minor detail, like in your tables, you can right click on the record selectors and choose to delete row. i want this specific feature disable. i tried changing the "Record Selectors" option to "no" in the form properties, but it still remains. any help would be appreciated.

Thanks!

 

[HiTechCoach]

i have a form being used as a sub form that is in datasheet view. it basically looks as if i have a table as my sub form. it is exactly what i want, except for one minor detail, like in your tables, you can right click on the record selectors and choose to delete row. i want this specific feature disable. i tried changing the "Record Selectors" option to "no" in the form properties, but it still remains. any help would be appreciated.

Thanks!

I would recommend setting the form's property for Allow Deletions to No

 

[SoxPats83]

ugh, once again an easy fix to a problem that i missed. thank you very much. also, HiTechCoach, i was hoping you would take a look at another thread of mine that references another thread you were previously instrumental in: http://www.access-programmers.co.uk/forums/showthread.php?t=192704

Thanks!