var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Passing a recordset object to a sub routine
I would like to pass a recordset object when calling a subroutine. The subroutine will move the recordset data to the form.
I tried coding the following(which is not allowed):
call move_data_to_form(rs1 as recordset)
Can I pass a recordset object to a called subroutine?
Thank you in advance for your help!
Sure; the "As Recordset" part would be part of the function, like:
Public Function PopulateLocalRes(ByRef rst As ADODB.Recordset)
and it's called like so:
If you use "Call", the argument(s) must be enclosed in parentheses.
I should add that the recordset variable probably has to be declared in a standard module.
Originally Posted by eva.thaeh
Are you using an ADO recordset?
If we understand what you need, hopefully we can help you find an Access solution. Would you please explain what you are wanting to do.
Yes, I am using a ADO recordset.
So is the issue resolved?