This is just a test page.
I am trying to figure out how to pick out a single record from a recordset without creating a new recordset.
In the sample case, I want to select a specific route number and display data from that record.
I will eventually have multiple routes to click on to display data from each one as a popup.
For now I just want to display on the screen the CompilerID just to show that I retrieved the correct data.
So I just need to get the syntax right.
The offending code is Line 49