If you recreate the grid's RecordSource (like with a SQL SELECT after the grid is created, it will show blank. In order to keep it, you need to save the grid.RecordSource to a variable, set the grid.RecordSource to "" (blank the value), do the SELECT, then reset the grid.RecordSource. There are other ways you may have to do this if your grid is set up with anything other than the default columns or different column order than the field order of the alias.
Fred On Fri, Feb 22, 2013 at 2:26 PM, John J. Mihaljevic < [email protected]> wrote: > Hi all, > > The other day, I asked a question about making a new form over a modal form > so my users could click back and forth between the two. Instead of doing > that, I figured I could accomplish the same thing by putting a new grid on > the form with a button to show/hide it. The show/hide thing is easy enough > (toggle the button to show it when it's hidden and hide it when it's > visible), but for some reason, I'm not seeing any grid rows or columns in > my > grid when I make it visible. The table is being populated (to test it, I > put > a BROWSE command in the code before the grid is to be made visible, which I > have since removed), but when the grid shows, all I'm getting is a solid > box. > > It would appear as though my settings are correct, but I'm obviously > missing > something. Here's the code I'm using to bring up the grid (I left out the > code that ZAPs and recreates all the records in the table as that's all > fine): > > select RecDisplay > go top > thisform.grdRD.visible=.t. > > And here are some of the properties in the grid: > > RecordSource = RecDisplay > RecordSourceType = 1 - Alias > > Any suggestions? > > Thanks very much! > > John > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJCBksoOCWBp_Om=fKFERx5OMOPpJAsXRpW=achlz3yybbi...@mail.gmail.com ** 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.
