-I have a function called getData() There is a select case which determines what SQL statement to use to load the records. Then it fills a tmpTable with the query results. Then it clones the tmpTable to tblAuthors.
-when my form loads it gets the Default case from the getData() .it loads the top 10 records from a sql server database
-then under the frmMain_KeyDown function when I press the up key, It then goes back into the getData() and selects the UpKey case, which is to select the top 1 record.
- The same thing for the Downkey except it gets the DownKey case from the getData()
-Once I press either the down or up key then my datagrid goes from showing 10 records to only displaying one.
- What I want for it to do is, always display 10 records but when I press the up or down key, I would like for it to scroll to the previous record or then next record but still displaying 10 records...(Not just 1).
- Any Help would be greatly appreciated!! Feel free to email me if you have any questions or comments. Thanks in Advance!!