Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941

    Unanswered: Recordcount on Subform

    I have a parent form (OpsPlan) with several subforms (subShip, subManuf, etc). I am trying to check the recordcount for each subform in the parent form's OnCurrent event. If there are no records on the subform, I need to take some action.

    I've tried several variations of

    Me.[subShip].RecordsetClone.Recordcount

    But I keep getting "Object doesn't support this property or method"

    Anybody have any ideas?

    Thanks
    Mark
    Inspiration Through Fermentation

  2. #2
    Join Date
    Jan 2007
    Location
    California, USA
    Posts
    520
    Me.[subShip].FORM.RecordsetClone.Recordcount

    I think you need to add Form. so you get to the form in the subform control.

  3. #3
    Join Date
    Jul 2003
    Location
    Michigan
    Posts
    1,941
    Thanks Vic!

    That was it. I figured it was something simple. I'm just out of practice on coding forms anymore.
    Inspiration Through Fermentation

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •