>I have a grid on a form, which services a number of files with exactly the same structure. Problem I am having is that I can't set the order programmatically. At the start the order is fine, but change the RecordSource, and try to set order, and nothing happens. I can put code in the header of a column, and physically click it, and then the order will change correctly, but if I click that header programmatically, it triggers the messagebox() I have there saying 'we are here!', but the code doesn't run. Click the header with the mouse, and it runs great. I am sure someone has battled this demon before. Thanks for your help!
Again
EVENT calls METHOD
the click in the header should do nothing then call a method, and this should do the job. If you need to force the same programatically, just call the method, never the event.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]