Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    Belfast, Ireland
    Posts
    339
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Filter hides the subform details . . . (2003 SP1)

    Sorry for making 2 posts in such quick succession, but I might as well get these queries answered all at once. [img]/forums/images/smilies/smile.gif[/img]

    Our Database consists of Companies with Branches. The User goes to the Company Form and then selects and opens the 'Branch Form' by clicking a Command Button on a Branch SubForm--the SubForm lists all the Branches with the Company ID (Set to Continuous Forms). Eg, Bank of America (the company) may have 50 Branches. When someone selects Bank of America, a Form opens that lists all 50 Branches. The user clicks a cmd to open the Bank of America branch they want to look at.

    On the Branch Form, there is a Command Button similar to 'Up One Level'. This was created using the Combo Box Wizard that allows you to open a Form where the IDs match. Therefore, when clicked, it simply opens the corresponding Company Form (in effect, taking them back to the Main Form--this means they can look at the Bank of America in New York, then return to the Company Form and open the Bank of America in New Jersey). However, occasionally (more often than not), the Company Form opens, but the Branch Subform is blank, ie, no Branches are displayed.

    Any clues why Access is so capricious with regard to displaying this SubForm?

    Thanks in advance for your reply.

    Brian

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Filter hides the subform details . . . (2003 SP1)

    Hello Brian,

    We'd have to know more about the forms and subforms, how they are linked and how they are opened.

  3. #3
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    Belfast, Ireland
    Posts
    339
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Filter hides the subform details . . . (2003 S

    Thanks Hans,

    As I recall, I'm sure I just added the Branch SubForm to the Company Form using the SubForm Wizard where CompanyID = CompanyID.

    The cmd that opens the Branch Form is just the code that's created by the CMD Wizard, ie . . .
    stLinkCriteria = "[branch_id]=" & Me![branch_id]
    DoCmd.OpenForm stDocName, , , stLinkCriteria

    Same to go 'Up One Level', ie . . .
    stLinkCriteria = "[company_id]=" & Me![company_id]
    DoCmd.OpenForm stDocName, , , stLinkCriteria

    Note: I didn't use an criteria in a Query as the User may want to just stay in the Branch Form and Navigate using the Find Combo Box I've placed on the Branch SubForm to jump directly to another Branch (rather than returning to the Company Form).

    HTH, and thanks again for your reply. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Filter hides the subform details . . . (2003 S

    I think we'd have to see the database. Could you post a stripped down copy? See <post#=401925>post 401925</post#> for instructions.

Posting Permissions

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