Parameters Again??

[Kahuna]

Hi Folks - as usual a simple one that's fried my brain!

Have a SQL string I'd like to use as a recordsource for a Report (in
OnOpen). Works fine except for the parameters where the SQL looks for
entries on an open form.

What's the syntax to define the parameters, considering I am intending to
simply make the SQL the recordsource, i.e.

Me.recordsource = strSQL

Help appreciated.

 

[JohnFol]

If you are making the recordsource, why not concatenate in the form values?
ie

strSQL = "Select * from Mytable where [FieldA]=" & Forms!FormName!FieldName
& " Order by fieldB""

 

[Kahuna]

Wot A Star

Believe it or not but I had assigned variable to the form values and
inserted the variables into the sql string. Guess what? I forgot to split
the text from the variable so in effect I had:

strSQL = "Select * from Mytable where [FieldA]= &
Forms!FormName!FieldName & Order by fieldB""

which will not work (of course).

Thanks John - I said it would be simple - fried brain and all!

Cheers

--
Kahuna
------------

If you are making the recordsource, why not concatenate in the form values?
ie

strSQL = "Select * from Mytable where [FieldA]=" & Forms!FormName!FieldName
& " Order by fieldB""

Hi Folks - as usual a simple one that's fried my brain!

Have a SQL string I'd like to use as a recordsource for a Report (in
OnOpen). Works fine except for the parameters where the SQL looks for
entries on an open form.

What's the syntax to define the parameters, considering I am intending to
simply make the SQL the recordsource, i.e.

Me.recordsource = strSQL

Help appreciated.