Dear Barbara and Nick,
Thank you very much, it works !
I have another question to ask. Now i will have a grid display in the form. And if i set the grid recordsource to the view, is it suitable to use view ? Since i need to filter the records from the view and only display the filter records on the grid.(eg. the view is an invoice file, and the grid only have to display the item which have same invoice no.)
And from that, i wish to add new item record or update or delete. And when i add item record, the grid can immediately to display and i which to reorder the records diplay on the grid by the item code.
Is it suitable to only use view ? and don't need cursor ?
thanks.

kengwen