Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Report Record Source

Discussion in 'Information Technology' started by Simon Harris, Jul 28, 2006.

  1. Simon Harris

    Simon Harris
    Expand Collapse
    Guest

    Hi All,

    I understand how to build a basic report, and how to set the record source
    to a table/query.

    Can someone please advise how I would do this dynamically? Heres the
    scenario:

    1) User searches for data (Done..Working)
    2) Matching data is then displayed in a sub_form in datasheet view
    (Done...Working)
    3) User asked via a prompt if they want to print the records found
    (Done...well, the prompt appears!)

    Next step - Open a report, setting the recordsource of the report to match
    the query that populated the subform.

    Any help will be much appreciated.

    Simon.

    --
    -
    * Please reply to group for the benefit of all
    * Found the answer to your own question? Post it!
    * Get a useful reply to one of your posts?...post an answer to another one
    * Search first, post later : http://www.google.co.uk/groups
    * Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Islamabad and Delhi agree on new bus link RECORDER REPORTISLAMABAD (September 29 2005): Pakistan and Breaking News Sep 29, 2005
    UK British Sikh Report-2016 Breaking News Mar 24, 2016
    1984 The Story I Did Not Report In ’84 History of Sikhism Jun 28, 2015
    Opinion Top Green Beret Officer Forced to Resign Over Affair With WaPo Reporter Breaking News Jun 26, 2014
    United Sikhs New Report Shows Increasing Hate Attacks on Sikhs Sikh Organisations May 21, 2014

  3. Simon Harris

    Simon Harris
    Expand Collapse
    Guest

    Might have solved it...is this an acceptable method?

    Private Sub Report_Open(Cancel As Integer)
    'Set the recordsource for the report so it matches the customer listbox
    rowsource
    Reports!RPT_currently_viewed_jobs.RecordSource =
    Forms!Frm_switchboard!JobsReportSQLStorage.Value
    End Sub

    "Simon Harris" <too-much-spam@makes-you-fat.com> wrote in message
    news:OkIyk%23hmGHA.3296@TK2MSFTNGP05.phx.gbl...
    > Hi All,
    >
    > I understand how to build a basic report, and how to set the record source
    > to a table/query.
    >
    > Can someone please advise how I would do this dynamically? Heres the
    > scenario:
    >
    > 1) User searches for data (Done..Working)
    > 2) Matching data is then displayed in a sub_form in datasheet view
    > (Done...Working)
    > 3) User asked via a prompt if they want to print the records found
    > (Done...well, the prompt appears!)
    >
    > Next step - Open a report, setting the recordsource of the report to match
    > the query that populated the subform.
    >
    > Any help will be much appreciated.
    >
    > Simon.
    >
    > --
    > -
    > * Please reply to group for the benefit of all
    > * Found the answer to your own question? Post it!
    > * Get a useful reply to one of your posts?...post an answer to another one
    > * Search first, post later : http://www.google.co.uk/groups
    > * Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!
    >
     
  4. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    If it works...

    Pieter

    "Simon Harris" <too-much-spam@makes-you-fat.com> wrote in message
    news:%23YFNr$hmGHA.1912@TK2MSFTNGP02.phx.gbl...
    > Might have solved it...is this an acceptable method?
    >
    > Private Sub Report_Open(Cancel As Integer)
    > 'Set the recordsource for the report so it matches the customer listbox
    > rowsource
    > Reports!RPT_currently_viewed_jobs.RecordSource =
    > Forms!Frm_switchboard!JobsReportSQLStorage.Value
    > End Sub
    >
    > "Simon Harris" <too-much-spam@makes-you-fat.com> wrote in message
    > news:OkIyk%23hmGHA.3296@TK2MSFTNGP05.phx.gbl...
    >> Hi All,
    >>
    >> I understand how to build a basic report, and how to set the record
    >> source
    >> to a table/query.
    >>
    >> Can someone please advise how I would do this dynamically? Heres the
    >> scenario:
    >>
    >> 1) User searches for data (Done..Working)
    >> 2) Matching data is then displayed in a sub_form in datasheet view
    >> (Done...Working)
    >> 3) User asked via a prompt if they want to print the records found
    >> (Done...well, the prompt appears!)
    >>
    >> Next step - Open a report, setting the recordsource of the report to
    >> match
    >> the query that populated the subform.
    >>
    >> Any help will be much appreciated.
    >>
    >> Simon.
    >>
    >> --
    >> -
    >> * Please reply to group for the benefit of all
    >> * Found the answer to your own question? Post it!
    >> * Get a useful reply to one of your posts?...post an answer to another
    >> one
    >> * Search first, post later : http://www.google.co.uk/groups
    >> * Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!
    >>

    >
    >
    >




    --
    ----------------------------------------
    I am using the free version of SPAMfighter for private users.
    It has removed 4079 spam emails to date.
    Paying users do not have this message in their emails.
    Get the free SPAMfighter here: http://www.spamfighter.com/len
     

Share This Page