Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2003
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report criteria form (2002)

    I have a main form that contains property records and a subform that contains jobs related to those properties. I want to put a command button on the main form that launches another form that will allow me to define what I want my reports filtered and sorted on. I'll want to be able to run reports for all properties or individual properties selected from a list box, I'll also have date fields (estimated start, estimated complete, actual start, estimated complete), in addition to some status flags (started, completed). Once the criteria is selected, I'll then want execute the report filtered and sorted based on the criteria form selections. I think I can handle setting up the criteria form, what I really don't understand is how to get the criteria values into the report filter and order by properties. I'm new to access and vba, which if you've read any of my previous posts I'm sure it's obvious. If anyone would care to share some guidance or possibly point me to sample code it would be greatly appreciated.

    I've said it before, but I really appreciate this website and all contributors to Woody's Lounge. Thanks for the help.

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

    Re: Report criteria form (2002)

    The following MSKB articles are for Access 2000, but the methods described there work for Access 2002 as well:
    ACC2000: How to Filter a Report from a Pop-Up Form
    ACC2000: How to Sort a Report from a Pop-Up Form
    Both articles contain a link to download the Sample Reports database; it contains working examples of these and many other techniques - very useful.

  3. #3
    2 Star Lounger
    Join Date
    Feb 2003
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report criteria form (2002)

    Thanks Hans, this is exactly what I needed. I'll give it a shot, I'm sure I'll be back with questions. <img src=/S/compute.gif border=0 alt=compute width=40 height=20>

Posting Permissions

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