No of records in subForm

P

Pantelis

On the OnCurrent event code of a Main Form I want to have the number of the
records that exist in the subForm and if there is a simplest way to know that
there are no record.
 
V

Van T. Dinh

Have you tried:

Me.[SubformControl].Form.RecordsetClone.RecordCount

?

(assuming the code is run in the context of the main Form)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate main form from subform record 0
Basing a subform on a selection from either of two subforms 3
VBA code returns no records hwenKey ID is added 14
set focus to control on subform 0
DLookup in Continuous form 0
Strange behavior and Error 2105 when oncurrent event cycles 0
OpenForm and Navigate to Subform Record? 1
Save record containing only default value 1

Top