Results 1 to 2 of 2
2004-04-14, 08:08 #1
- Join Date
- Jan 2001
- Lewes, East Sussex, Sussex, United Kingdom
- Thanked 0 Times in 0 Posts
Column sorting on subforms (A97 SR2)
I have a problem with selecting a column and then sorting on it when a form is opened in datasheet mode.
I have created a short-cut menu for use on these forms, and when the form has no sub-form right-clicking
on the column heading correctly shows the menu I created.
However, when the main form contains a sub-form in datasheet mode right-clicking the column heading
shows nothing if the main form's ShortCut Menu property is set to No, and the Access shortcut menu
(Sort Ascending, Sort Descending, etc) if the main form's ShortCut Menu property is set to Yes.
If I right-click on the body of the sub-form then I get the shortcut menu which I created.
Does anybody know how I can right-click on the sub-form column heading and see the shortcut menu I created ?
Access does not seem to want to show it.
Thanks for any help
2004-04-14, 08:22 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 Posts
Re: Column sorting on subforms (A97 SR2)
I don't think you can do this with a datasheet subform. You can set the Shortcut Menu property of the subform to Yes while that of the main form is set to No, but the custom shortcut menu will only be displayed if you right-click on a record; if you right-click a column header, the built-in shortcut menu will be displayed.
You will have to create a continuous subform that looks like a datasheet.