CODEWITHSUNDEEP
ms-accesssubforms
Kefash
Kefash

Reputation: 533

MS Access turn off shortcut menu on subform

I have a MS Access form that has a subform. the subform is in datasheet view and is sorted and sorted by the date column. I have a button that does a comparison checks using the first row in the subform before performing an update, and it works fine. The problem is whenever a user right click in the subform and resort the data it causes problems. Is there a way I can prevent users from sorting the subform? also, if I should turn this off will the data still be sorted by the date field?

Upvotes: 1

Views: 2225

Answers (1)

jpw
jpw

Reputation: 44871

The form should have a property Shortcut Menu that controls the ability to right-click when the form is in browse mode. Set that property to false to disable right-click (and sorting etc). The data should still get sorted as that is controlled by the Order By and Order By On Load properties.

Upvotes: 2

Related Questions