General discussion

Locked

Access 97 Data Source

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.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

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.

Collapse -

Access 97 Data Source

by johndjauch In reply to Access 97 Data Source

Confirmed this worked. Thanks.

Collapse -

Access 97 Data Source

by johndjauch In reply to Access 97 Data Source

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums