Ok, havin trouble with populates now...grrrr ANyway. I have 2 grids. Each grid populates a table. When I select a record in Grid 1, the table in Grid 2 is to filter. The problem I'm having is that the tables will populate On Load, but when I click a record in Grid 1, it filters the table in Grid 2 to say that there's no record. However, the table has 5 records in it. Here's my code for Grid 1 on Click, I'm hopin someone can shed some light, thanks!

Private Sub hfgActiveGrid_Click()

intCrossRefID = _
hfgActiveGrid.TextMatrix _
(hfgActiveGrid.Row, 0)

intCrossRefID = 0

txtPrime.Text = ""
txtSecond.Text = ""



If intCrossRefID < 0 Then

hfgPrimeGrid.Rows = 0
hfgPrimeGrid.Clear

Else

txtPrime.Text = _
hfgActiveGrid.TextMatrix _
(hfgActiveGrid.Row, 1)

End If

'Retrieve info and establish connection

strPrimeCrossRef = _
"sp_GetActivePrimeInfo " & _
intCrossRefID

GetPrimeGrid_Data _
strPrimeCrossRef, _
"js_intCrossRefActiveSecondID", _
"Active Data:" _
"js_intActiveID", _
"js_strActiveName",_
hfgPrimeGrid

hfgPrimeGrid.RowSel = 1

End Sub