Results 1 to 12 of 12
  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Location
    USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Subforms (Access 2000)

    Hello,

    I have a user who would like to review the net returns of 4 mutual funds at one time. The user types in the individual fund id to run the queries. So far, I have a main form and 4 subforms that are able to accomplish this. However, now the user would like to delete one of the funds and add another without changing the other 3. (Each subform is attached to its own query.) How do I keep the main form intact without starting all over?

    Is this done with a macro?

    Thanks.

  2. #2
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subforms (Access 2000)

    Would I be correct in assuming that you have 4 combo boxes on your main form and you select the ID in each box for each of the subforms and that the combo box selection supplied the criteria for the query each subform is based on? Or have you designed a different solution?

  3. #3
    Star Lounger
    Join Date
    Mar 2001
    Location
    USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subforms (Access 2000)

    Rupert,

    In the critieria of the underlying query, it asks for a fund id. The user then types it in and the query runs.

    Thanks.

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subforms (Access 2000)

    Four times?

  5. #5
    Star Lounger
    Join Date
    Mar 2001
    Location
    USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subforms (Access 2000)

    Yes.

  6. #6
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Subforms (Access 2000)

    Add a button to your subforms to requery the recordsource. This should again ask you for a the fund ID.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  7. #7
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Subforms (Access 2000)

    >>It doesn
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  8. #8
    Star Lounger
    Join Date
    Mar 2001
    Location
    USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subforms (Access 2000)

    Mark,

    This sounds very easy, but I am unsure what steps to take to do this. When I make command buttons, I use the wizard. Do I run a macro to requery? If so, when I have the action that says requery, what do I put in the control name.

    Thanks for your help.

  9. #9
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subforms (Access 2000)

    What

  10. #10
    Star Lounger
    Join Date
    Mar 2001
    Location
    USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subforms (Access 2000)

    They are in continuous view.

  11. #11
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subforms (Access 2000)

    As to your question about the command button and running the query with a macro, I think you would be better off using the

  12. #12
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subforms (Access 2000)

    So an idiot would eventually turn in to an expert. Yes! I like the sound of that. Some experts I know were obviously idiots in the past and I

Posting Permissions

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