Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Can you return recordsets in functions
- Thread starter TLiberty
- Start date
Sure can,<br>
<br>
Set rs = GetRecordSet(strSQL)<br>
<br>
Then the function looks like this:<br>
<br>
Public Function GetRecordSet(strSQL as String) As RecordSet<br>
Dim NewRS as Recordset<br>
<br>
Set GetRecordSet = NewRS<br>
Exit Function<br>
<br>
Steve<br>
<A HREF="mailto:sdmeier@jcn1.com">sdmeier@jcn1.com</A>
<br>
Set rs = GetRecordSet(strSQL)<br>
<br>
Then the function looks like this:<br>
<br>
Public Function GetRecordSet(strSQL as String) As RecordSet<br>
Dim NewRS as Recordset<br>
<br>
Set GetRecordSet = NewRS<br>
Exit Function<br>
<br>
Steve<br>
<A HREF="mailto:sdmeier@jcn1.com">sdmeier@jcn1.com</A>
- Status
Similar threads
- Locked
- Question