General discussion

  • Creator
    Topic
  • #2084071

    Access 97 Data Source

    Locked

    by johndjauch ·

    We want to create a textbox in a MS Access 2000 report that shows what the current datasource is. We intend to change the datasource but use the same report.

All Comments

  • Author
    Replies
    • #3771672

      Access 97 Data Source

      by sdwasson ·

      In reply to Access 97 Data Source

      1. Place an unbound textbox (txtRecSource) in the Report Header (or other report section, but adjust the event accordingly!)
      2. Insert this code into the ReportHeader_Format event…

      Me!txtRecSource = Me.RecordSource

      Access will write thename of the current Record Source to the text box.

    • #3788201

      Access 97 Data Source

      by johndjauch ·

      In reply to Access 97 Data Source

      This question was closed by the author

Viewing 1 reply thread