Form & Subform Searching

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • z.ghulam@gmail.com
    #1

    Form & Subform Searching

    Hi,

    I have 2 subforms embedded within a main form. Whenever I do a Filter,
    the data in the main form appears, but nothing shows in either
    subform?

    Is there a way round this?
    I was using the Filter-by-Form button on the toolbar.
    I've also got a Find Record button on the form...
    DoCmd.DoMenuIte m acFormBar, acRecordsMenu, 0, 2, acMenuVer70

    and the the filter button .....
    DoCmd.DoMenuIte m acFormBar, acRecordsMenu, 2, , acMenuVer70

    Any help would be greatly appreciated
    Cheers
    Zieshan
    Tags: None
    • z.ghulam@gmail.com
      #2
      Re: Form & Subform Searching

      On May 28, 12:53 am, z.ghu...@gmail. com wrote:
      Hi,
      >
      I have 2 subforms embedded within a main form. Whenever I do a Filter,
      the data in the main form appears, but nothing shows in either
      subform?
      >
      Is there a way round this?
      I was using the Filter-by-Form button on the toolbar.
      I've also got a Find Record button on the form...
          DoCmd.DoMenuIte m acFormBar, acRecordsMenu, 0, 2, acMenuVer70
      >
      and the the filter button .....
      DoCmd.DoMenuIte m acFormBar, acRecordsMenu, 2, , acMenuVer70
      >
      Any help would be greatly appreciated
      Cheers
      Zieshan
      Problem solved!!

        Comment

        Previous template Next
        Working...