Does that mean put both views on but hide one and just show the active view. That is a cool solution. [there is only 2-sorts] Sounds messy but I could play with it
-----Original Message----- From: Kurt @ VR-FX [mailto:v...@optonline.net] Sent: Saturday, January 28, 2012 8:30 PM To: profox@leafe.com Subject: Re: gids and views Or - I think this should work - and the fields are different - you can specifically change the Control Source on each Grid item. Alternately - you could have Multiple Grids defined on the Same form - and ONLY show the grid for the Active View - and hide the other Grid(s). Regards, Kurt On 1/28/2012 7:30 PM, Dan Covill wrote: > On 01/28/12 14:58, Gary Jeurink wrote: >> I know how to switch the contents sort of a grid connected to a table with a >> set of buttons using SET ORDER TO but when I'm using a view and I want to >> change from one view to another on the same grid is there an easy way other >> than another form. Be Kind BECAUSE I'M SELF TAUGHT. > When you change the source table/cursor/view for a grid, it loses all > its brains in regard to columns, etc. So, before you change, you have > to clear the .ControlSource, make the switch, and then re-set the > .Controlsource afterward. > > This, of course, assumes the field/column names are all the same!<g> > > Dan > [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/E9F1626DF86346EC87D433A252E4A371@OwnerPC ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.