Hi
I am using this this to fill up my continous form with different text field in it

Dim cmd As New ADODB.Command
Dim prm As ADODB.Parameter
Dim r As New ADODB.Recordset

cmd.ActiveConnection = SQLcon
cmd.CommandType = adCmdStoredProc
cmd.CommandText = "sp_Order"

Set prm = cmd.CreateParameter("@SDATE", adDBTimeStamp, adParamInput)
cmd.Parameters.Append prm
cmd.Parameters("@SDATE").Value = Format(Me!DateSearch, "yyyy/mm/dd hh:mm:ss")

Set prm = cmd.CreateParameter("@CUSER", adInteger, adParamInput)
cmd.Parameters.Append prm
cmd.Parameters("@CUSER").Value = CUser()
Set r = cmd.Execute()

'THIS LINE GIVE ERROR
'Set Me.Recordset = r

'THIS CODE BELOW ABLE TO PRING VALUES IN DEBUG SCREEN
While Not r.EOF
Debug.Print r!Rep & " , " & r!MID & " , " & r!TDate & " , " & r!Value & " , " & r!SDATE & " , " & r!ElecOrMach
r.MoveNext
Wend

any idea

Regards

Ayaz

Hi...

What error?

__________________
HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========

Hi

Thanks for your reply

Run-time error '7965'

The object you entered is not a valid recordset property

then i change it to

Set me.recordsource = r

Compile error
Invalid use of propert

I can't even do something like

me.txtfield = r!value2

Regards

Ayaz