>>>Your view must be an updatable view.
>>>
>>>I also have this as two pagespageframe form - first is a Grid View and second is a one record view with all fields.
>>
>>ok i did the thisform.refresh,grid is readonly.
>>but help me here
>>where do i set the form view to updatable and also when u say form has 2 be bound 2 the same view u mean my fields need 2 have the view as its control source?
>
>When you design the view in the View Designer there is a tab for Marking which fields are updatable and how the updates are send to the table. You also need to identify the primary key there.
>
>Yes, your textboxes will have MyView.Field as their controlsources. The Grid will have myView as the RecordSource as well.

oh the edit box and grid works but the values doesnt get updated

in the view designer i see Update Criteria.
I also see all my field for my grid. but none of them are keys. Do i need 2 click the "key" and "pencil" icon?
oh SQL updateS?