S
spoono
Hi
I have an ADP that sets the bound forms Recordsource to the results of
a stored procedure. The code in VBA I have that sets the forms
recordsource
is:
[Forms]![frmData].RecordSource = "EXEC usp_SelectSubSet3 " & strCrit &
"," & strSearch
This is all cool until the SP doesn't return any results i.e The
search criteria didn't find any matches. The form freaks out because
it's RecordSource is empty.
Anyone have any ideas with code on how I can test to see if the Stored
Procedure returns any rows before I set the forms Recordsource to the
results of the SP?
thanks
Simon
I have an ADP that sets the bound forms Recordsource to the results of
a stored procedure. The code in VBA I have that sets the forms
recordsource
is:
[Forms]![frmData].RecordSource = "EXEC usp_SelectSubSet3 " & strCrit &
"," & strSearch
This is all cool until the SP doesn't return any results i.e The
search criteria didn't find any matches. The form freaks out because
it's RecordSource is empty.
Anyone have any ideas with code on how I can test to see if the Stored
Procedure returns any rows before I set the forms Recordsource to the
results of the SP?
thanks
Simon