as i said my command type is a stored proc.
the command is given in a DataEnvironment

so i have tried :
DataEnvironment1.rscmdApproved.Requery

(.refresh is not an option with the recordset)

but i get the error
"no value given for one or more required parameters"

the sp has no in/out param. it is a simple select query
(but i cannot use the table as a command type)

any ideas.......