Results 1 to 7 of 7
  1. #1
    Join Date
    Nov 2002
    Posts
    37

    Unanswered: Filtering in subforms with tab control

    I can filter for information on the main form but not in the subform or any of its tabs.
    Can anyone please help me ?

  2. #2
    Join Date
    Nov 2002
    Posts
    37

    Re: Filtering in subforms with tab control

    I can use the filter option it just does not filter correctly.

  3. #3
    Join Date
    Oct 2002
    Posts
    48

    How you paste subform ???

    When you paste subform in main form, it asks for relationship.
    You can have certain no. of fields common in both form. You have to choose them.

    even if you are missing them to choose(exstablish relationship), you can do it later also, by going to tab/subfrom's property.

    ----

    If you have 2 diffeent forms. 1 parent form, another child form, but independent(not pasted like subform) . May be you can use me.refresh. So, relationship key will be refreshed, and you will get latest info for relationship.

    --

    I am not sure, what you are asking. but clarify more to correct me.

  4. #4
    Join Date
    Nov 2002
    Posts
    37

    hmm

    I am using Access 2002.
    I recall the parent child relationship in older versions of Access but 2002 does not have the same properites.

    It appears that each subform is linked with the master form as both control sources are the same "table".
    If I filer from the master form I get proper records in the subform, but if I filter in the subform I get blank data in the subform but the master form information stays the same.
    Would I be using the me.refresh on the filter event ?

    Any thoughts ?

  5. #5
    Join Date
    Nov 2002
    Posts
    37
    please forgive my bump

  6. #6
    Join Date
    Oct 2002
    Posts
    48

    I dont think, you can further filter sub form records.

    May be based on parent table's condiotn, you want to get certain records, and then again ou want to filter them.

    Then, instead of making subform, make separate/independent form, consider it as subform.

    'forgive bump', I dont understand. Sorry.

  7. #7
    Join Date
    Nov 2002
    Posts
    37

    Re: I dont think, you can further filter sub form records.

    Some people use the phrase "bump" when they would like to get their thread at the top of the forums.

Posting Permissions

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