ADODB Recordset won't work

[Graham R Seach]

<<I'm not so sure that I agree with that; kid>>
Great! Then use your knowledge to help solve Keith's problem.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

I'm not so sure that I agree with that; kid

if you want to spread mis-information you'll have a hard time in this
newsgroup

Keith,

Your error says "No value given for one or more required parameters".
That
means a required parameter is NOT being given a value. There are only two
parameters I can see which would fire that particular error.

Is this an MDB or an ADP?? If you're in an MDB, then you can't use
CurrentProject.Connection, because the CurrentProject doesn't have a
connection. In that case, you're probably better to use DAO.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Thanks Graham:

ProgramType is Mid([strProgramNumber], 6, 2) for the current record on
a continuous form. The value is assigned before I get to this point in
the code, and it work.

What I'm trying to do is find the program type ("S1" or "S2") imbedded
in the program number of that record, and then lookup various program
completion requirements in tblPrograms for the program of that type.

On Apr 28, 10:32 pm, "Graham R Seach" <[email protected]>
wrote:
Keith,

Your code looks OK, but I don't see where ProgramType is defined or set.
I'm
guessing that since you didn't get an error at line 2, that you're simply
not supplying a value for it.

 

[Larry Linson]

BECAUSE ADO WON?

No, that certainly couldn't be the reason, Mr. Kempf.