Results 1 to 5 of 5

Thread: Critique (97)

  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Critique (97)

    Critique
    I

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Critique (97)

    What you are proposing should in theory work. One thing you will want to do is to bind your subform in code rather than doing it at design time. In point of fact you may want to do it dynamically by changing the link fields for the subform control.

    Another alternative would be to put the selection controls in the header of a form, and then build a filter dynamically that would let you reduce the record set to what you want. You could use the same approach with a subform, but there isn't much reason for the subform at that point. I frankly suspect that approach would be less problematic as well. We do lots of work with subforms, but they can be a source of both performance problems and errors when things change or go wrong.

    As to updating the records, you will probably want to do that behind the scenes but either running an update query, or by opening a recordset with the appropriate WHERE clause and stepping though the records one at a time an updating them. You will need to refresh or requery your form after you have done either.

    Hope my rambling is helpful.
    Wendell

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Critique (97)

    Your rambling is appreciated <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  4. #4
    4 Star Lounger
    Join Date
    Jun 2001
    Posts
    531
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Critique (97)

    well Wendell, I thought I

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Critique (97)

    The filtered forms approach can be made to look almost exactly like the subform approach if you make the form a continuous form, so as the filter is applied, you see the number of records being reduced. I think either approach can be made to work, but the code for the subform approach is likely to be a little more complex. Sounds like a fun project!
    Wendell

Posting Permissions

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