basic grid issue...

[tristero]

i have a grid with the recordsource/columnsource set to an alias.

however i want to change the table for this grid so i have the user select which table using an optiongroup which has a click event that closes the current table and opens a different table with the same alias.


i can't get this to work just by doing a grid.refresh()... why not?


i can figure a way to make it work by redefining the table recordsource/columnsource, but i have a grid.column.text.dblclick() event that gets lost in the process.


please help.... thank you.

Dan Trenz
Ann Arbor, MI

 

[DSummZZZ]

Try setting RecordSource to "" (empty double quote) first, then to your new table/cursor.

MyForm.grid1.RecordSource = ''
USE SomeTable ALIAS NewTable IN 0
MyForm.grid1.RecordSource = 'NewTable'

-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm