I have a form that shows continus details based on several queries depending which buttons you have clicked.
I have identified which query is in use and have got its sql code by using:-
stsql = qr.SQL
where qr is defind as "QueryDef" and stsql is defind as String
when I try and use this string as an argument to open up a record set it gives the following error.
"No value given for one or more required parameters"
I have working on it all day and can not work it out, can anyone be of assistance.
I have attached screen dumps of the code and the messages to assist.
Thank you in advance.
ANP
I have identified which query is in use and have got its sql code by using:-
stsql = qr.SQL
where qr is defind as "QueryDef" and stsql is defind as String
when I try and use this string as an argument to open up a record set it gives the following error.
"No value given for one or more required parameters"
I have working on it all day and can not work it out, can anyone be of assistance.
I have attached screen dumps of the code and the messages to assist.
Thank you in advance.
ANP