>I am requerying a grid
>
>requery('lv_promotion')
>
>How can I get the most recent values from this requery (how do I access the values of last record in this requery)? Help appreciated
>
>
>Thank You
>Nick Patel
Hi Nick,
Correct me if I am wrong, I understand that you have a view which is the RecordSource of your grid. After REQUERY() what do you mean by most recent values? If you want to show your last record (which probably contains the most recent somedate field) you may GO BOTTOM in your view and refresh the grid. Or, if you want the last (most recent record) be on top then you may add ORDER BY mydatefield DESCENDING and have it as first record in the grid.
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison