smalloy
Posts: 107
|
| Posted: 11/12/2004, 8:01 AM |
|
I have a search Form that links to a grid (master) and another grid that shows the detail (detail). The master grid has a navigator so the user needn't have to do a search but can use the navigator instead. My issue is that the detail grid does not update when the master does. I tried the datasource link to the Master but it doesn't work. In an effort to overcome the issue I changed one of the fields to a link that updates the detail grid but if the user changes the master the detail shows the last one which will confuse the user since it is not the detail foir the correct master.
I then tried this code in the Master Before Show Event but it still doesn't work even though the page refreshes when the navigaor is used:
Dim intFileID
If NOT isEmpty(request.QueryString("File_ID")) Then
intFileID = request.QueryString("File_ID")
tbTransactions.Datasource.SQL = "SELECT * " & _
"FROM tbTransactions"
tbTransactions.Datasource.Where = "[File_ID] = " & _
intFileID
tbTransactions.Datasource.Order = "[ServiceDate]"
End IF
Any ideas?
Thanks!
_________________
Anything can be done, just give me time and money. |
 |
 |
|
