i tried requery too.
it works fine when the command type is a table. but when i use a stored procedure requery too gives an error.

to show u the code i'll have to show the whole app.
btw, frm1 has a datagrid populated by the sp n i want the fields in the datagrid refreshed