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