Passing Multiple Parameters

[pmaxon]

I am using VB6, CR8.5 OCX. I have a form which uses a combo box to pass a parameter to a report. I now need to add another parameter from a text box on the same form. I am currently using:

.ParameterFields(0) = "sLName;" & Combo1.Text & ";TRUE;"

to pass the original parameter. How do I also pass the second parameter to the report? They need to be passed at the same time. The parameter field on the report is sYear and the text box on the form is txtYear. Unfortunately, it is not as simple as adding:

.ParameterFields(1) = "sYear;" & txtYear.Text & ";TRUE;"

TIA!

 

[vidru]

That's the correct syntax. Are you getting an error?

-dave

 

[pmaxon]

Well... no...
I was but now it seems to be working fine. ) Hooray! Thanks anyway Dave and hope all is well with you.

Pat