Sorting a form field

[integritycare]

Hi Guys,
Just a quick way of being able to sort any field on a form.
If the form property Shortcut Menu is set to "Yes" its ok, but when set to "No" it does not seem possible to do so. If the Shortcut menu is set to Yes then the form can be seen in design mode.
How can a sort be added without the design mode showing.

Thanks,

Integrity

 

[TheAceMan1]

How are ya ntegritycare . . .

If your looking to override the Shortcut Menu property, try the Order By property:

[blue]   Me.OrderBy = "[[b]FieldNameHere[/b]]" [COLOR=#4E9A06]     'Ascending[/color]
   Me.OrderBy = "[[b]FieldNameHere[/b]] DESC" [COLOR=#4E9A06]'Desccending[/color][/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]