Most of my data entry forms in my application are based on cursors. I have a new order entry form, and would like to use a view. I have the form set up so the user will enter the sku, qty, price ect. in text boxes. When the focus leaves the last text box the line item gets inserted into my view.

I am having trouble getting the last record entered to be at the top of the grid. I tried setting the order of my view to the primary key descending, but that only seems to work when I requery() the view.

Any ideas would be appreciated.

Pat Murphy