Count records loaded by subform

[ragnarok75]

I have a form that loads a subform. The subform is based on a query. How do I count the number of records that the subform loads and then execute a procedure if it loads more than 1 record?

 

[Remou]

You can refer to the recordcount property of the recordset for the subform.

 

[ragnarok75]

How do I refer to the data already loaded?

 

[Remou]

It depends on where you are referring to it from. Let us say the main form.

[tt]Me.[Subform Control Name].Form.Recordset.RecordCount[/tt]

 

[ragnarok75]

Can I specify one field to load into the recordset?

 

[Remou]

You are losing me. Do you mean (?):

Me.RecordSource ="Select ThisFieldOnly From ATable

 

[gwinn7]

Several examples...

E#1
myrecordcount = dcount("myfield","mytable","myfilter")
E#2
set rs = me.subform.form.recordsetclone
rs.movelast
myrecordcount = rs.recordcount
E#3
' Modified form recordsource...
Set rs = db.openrecordset("SELECT count(myfield) FROM mytable WHERE myfilter", dbopensnapshot)
myrecordcount = rs(0)

My preference is #3, because it is very fast when you are loading 10K+ records, but #2 is more applicable. I hate using the Dcount/Dsum functions.

I did not suggest recordcount because my prior experience told me that recordcount was not instantly reliable. I believe it was depending on when JET got done assessing the size of the recordset.

Gary
gwinn7