help searching subform

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • sweetfee
    New Member
    • Oct 2007
    • 5
    #1

    help searching subform

    i have a cus_form that has a subform on it, each customer is allowed to have three sharers on their box. i could search the main form for the box owner but i can't search the subform with out having it open the subform by itself. there is a one to many relationship with the main form and the subform.
    Tags: None
    • nico5038
      Recognized Expert Specialist
      • Nov 2006
      • 3080
      #2
      Originally posted by sweetfee
      i have a cus_form that has a subform on it, each customer is allowed to have three sharers on their box. i could search the main form for the box owner but i can't search the subform with out having it open the subform by itself. there is a one to many relationship with the main form and the subform.
      What's the exact question ?
      To determine the number of owners of a box, the Dcount() function can be used, but it would be better to have an Owner form with box selection to show the number of sharers for a box.

      Nic;o)

        Comment

        Previous template Next
        Working...