I'm using SQL Server backend on an Access 2K front end.
I populate a subform:
Forms!myForm.myChild.Form.RecordSource = "myStoredProcedureName"
On that form is a control where the controlsource is "=
Count([UniqueID])"
that shows the user the number of records.
What I'm doing now is populating the subform, using the
RecordsetClone.RecordCount of the subform to determine if any records
were returned, and if not, opening a message box telling the user that
no records were returned and closing the form.
Tat seems like a huge waste of resources.
There has to be a better way to do this, within the stored procedure?
lq
| 
