Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jun 2002
    Location
    San Antonio, Texas, Uganda
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Creating a Report from the active form (Acc2000)

    In the past, I've created a report based upon a query that was based upon the Active Form using the EventID (autonumber field) The criteria would be [Forms]![frmEvent]![EventID].
    I want to upsize the database to a SQL backend. The query that supports the report won't "upsize because it depends on a Form parameter"
    Any ideas?
    Could I do VBA that says take value of a field in the form and make it equal to the value of the field in the report?

    Thanks in advance

    PVan

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Creating a Report from the active form (Acc2000)

    Reports and forms don't "upsize", although the queries they're baed on may. Is that what you're talking about?
    Charlotte

Posting Permissions

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