467,081 Members | 1,196 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,081 developers. It's quick & easy.

Count records on a subform recordsource before/after populating?

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
Nov 12 '05 #1
  • viewed: 3240
Share:

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

9 posts views Thread by BLUE WATER | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.