Discussion Locked

Access 97 Data Source

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.

3 replies

by sdwasson

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.

This discussion is closed to new replies.