>I have 2 grids on a form. The first grid contains a clients name and where the clients tables are stored on the network. Like:
>
>column 1 column2
>Clientabc d:\clientabddir\
>
>I want the information in column 2 of grid1 to change the record source of grid 2. I put this in the when event of grid1:
>
>thisform.grid2.recordsource = Alltrim(thisform.grid1.column2.text1.value) + "charges.dbf"
>
>thisform.grid2.refresh()
>
>I get nothing.
>
>I must be missing a property or something. This seemed like it was going to be easy at the onset.
>
>Jill
Grid expects to have alias as recordsource, i.e. you should open the table and use its alias afterwards, e.g.
USE c:\...\charges in 0 alias mycharges
thisform.grid2.recordsource="mycharges"
thisform.grid2.recordsource
Also, the appropriate place would be grid1.afterrowcolchange event.
Edward Pikman
Independent Consultant