Subcount before recordsource finished

[rmm13]

I have a search form for last and first names which populates a subform
Me!fmFamilies.Form.RecordSource = my query
on the subform I have a count in the footer to do a subcount
LCount = Me!fmFamilies.Form.SubCount
this determines if any records were returned, and if not, opens a message box telling the user that no records were returned.

Problem is if there are more that 7 entries - i.e when Last name is Smith, it seems to be counting before the code above has actually
populated the RecordSource and I get the no records returned. Is there a way to speed up the total calculation on the subform - or a way to delay the message so the total is correct.

 

[John Big Booty]

Why not test for;

Me.RecordSet.RecordCount = 0

 

[rmm13]

Just to test I made
LCount = Me!fmFamilies.Form.Recordset.RecordCount

Works great - I'm clean up the rest now

Thanks