Greetings:)
I've got a form with a grid on it...I have 4 boxes at the top that the user can fill in and then hit the search button and it compiles a SQL statement into an initial cursor with all the fields I want to use, then it pulls only 4 fields into a secondary cursor that is used by the grid, and ORDER BY the PartNo at first, then they can hit the header of the column they want to have the list sorted by and the second SQL statement is run again only this time with the ORDER BY the field for that column.
Now here's the tricky part; I want to enable my users to be able to double click on a row and then a details form would show up with the details about that particular part number(basically all the fields in the first SQL statement); but I want it to use the ORDER BY field from the second SQL statement. Also, I've got a navigation bar on the details box because it'd be nice for them to scroll through the results...
I've got this all working except for the details box...I can't seem to get it to use the correct cursor, nor can I get it to go to the correct record... or something, at this point I'm not sure what to try...so ANY suggestions, like a better way to do this, would be GREATLY appreciated:)