Kevin,

It is better to not repost a question, unless it has been a few days an your problem is not resolved.

Why are you apposed to using an updateable p-view for your grid?

Personally, I don't like grids for data entry. I use a listbox to show the child records, and use a SELECT statement as its recordSource. The user can double-click (or press enter on a highlighted record) to edit the record in a simple, modal child form.

>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
>
>I do not want to change the order to assending either that would confuse the user too much.
>
>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