RecordsetNavBar with Parameterized queries 2

[giorgioc]

I'm creating a recordset using the value in a combo to retrieve from a SQL Server DB only the records I need.

It works fine. I attached to the recordset a RecordsetNavBar
in order to move throught the records.
I also included some code to generate a table with a grouped version of teh contents of the recordset.

When I hit the buttons of the navbar, the textfields linked don't change values and the table disappears (I think the recordset is destroyed during the roundtrip to the server).

Any ideas on how to solve this problem ?

 

[tmishue]

giorgioc,

Try going into the properties of your DTC Recordset to the Implementation Tab and select to Preserve your Recordset in Session State. It worked for me. I was having the same problem and your question helped me to find out what was happening. Thanks

tbmishue