I built a grid that references a table and set it up where when the user enters an acccount number (primary key), the grid displays only those records that have that account number as the primary key. This is great, the only problem with it is I want the grid to display the last 6 records of that account number as a default on the grid. When I run the form and click on the grid it still only shows the account number I want, but I would have to manually scroll down to get to where it shows the last 6 within the grid. now if i try to either on the lost focus of the loan account input box or in the refresh of the grid itself, do a refresh, the grid goes blank. It is not built with SQL view, I want direct access to the table itself so the user can change values within directly to the table. you can tell on the status bar that it is skipping records, but it is blank. If i programmatically reset the values I applied to it's properties it will seek the account number I want, skip how many times i want, but the grid goes back to showing me all account numbers in the whole table again instead of just the account number entered in the input box that gets seeked.

How do I get my grid to continue to only show the loan_acct I seeked on and at the same time be able to skip the pointer to where it shows the last 6 within the grid with the ability to scroll up and see the ones before the last 6, etc. and not blank out the grid or revert back to showing all the accounts in the table?

Here is how my table is set up that gives me initially only showing the account number I entered:

pmtinput.grid1.recordsource = 'borrpmt' <- borrpmt is the table
pmtinput.Grid1.RecordSourceType = 1 <- referenced by alias
pmtinput.grid1.ChildOrder = 'loan_acct' <- index tag by primary key loan_acct

Thanks for your time,

Kevin Hickman

Please reply back here, but can you also send me an email to gocadle@neo.rr.com attn to Kevin