Detect Subform with No Records

[fredzeppelin]

Situation: Form with subform, linked parent/multiple child with referential integrity enforced.

Processing with pretty deep code. On occasions, the subform has no retrieved records(rare, but expected in one specific situation). Subsequent assigning data to field of non-retrieved record fails (of course, it doesn't exist!)

What's the best/any way to programmatically detect that subform has retrieved no records?

Main form is open, records are flying, data is processing...

    With [Forms]![frmpartdetailmultiform]![sfrPartRefurb].[Form] 
            'need to skip these if no linked record
            .ReturnDate = dtmEffDate  
            .ReturnLocation = stDestUnit

If linked subform sfrPartRefurb has no record(s), the assignment fails.

Haven't touched Access Basic/VBA in months,
I'm trying IsNull, IsEmpty, IsAnybodyBackThere?

What's the right way?

thanks, brad

 

[fredzeppelin]

Whoops, I tried the FAQs again with different key words, and found a suggestion.

Create a recordset from the subform linkfield criteria and count it.

I'll go try that.....

thanks again