While Not recLoad.EOF
iXValue = rs!XValue
iYValue = rs!YValue
rpt.AddToFieldDetails "CaseSheetName", iXValue,iYValue
rs.MoveNext
Wend
Problem:
"rpt.AddToFieldDetails "CaseSheetName", iXValue,iYValue"
Here, "casesheetName" all the record values are getting loaded, where as i want only one record value to be loaded at a time.
so, i want a statement like this:
"rpt.AddToFieldDetails rs!CaseSheetName, iXValue,iYValue"
(where casesheetname is the field name)
But, unfortunately it's not accepting this..
Please clarify.
iXValue = rs!XValue
iYValue = rs!YValue
rpt.AddToFieldDetails "CaseSheetName", iXValue,iYValue
rs.MoveNext
Wend
Problem:
"rpt.AddToFieldDetails "CaseSheetName", iXValue,iYValue"
Here, "casesheetName" all the record values are getting loaded, where as i want only one record value to be loaded at a time.
so, i want a statement like this:
"rpt.AddToFieldDetails rs!CaseSheetName, iXValue,iYValue"
(where casesheetname is the field name)
But, unfortunately it's not accepting this..
Please clarify.