Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

RECORDSOURCE FOR MY REPORT

Status
Not open for further replies.
619Ghz

619Ghz

Programmer
Dec 3, 2003
17
US
To avoid creating at least 30 different Reports in Access 97, with the big memory (and work) overhead I would like to set the Report' s RecordSource property using VBA code. How can I do this. I have failed miserably using all 'known methods' . Please save me!!!
 
Sort by date Sort by votes
add RecordSource = "TableName" to the report open like this:

Private Sub Report_Open(Cancel As Integer)
RecordSource = "TableName"
End Sub
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
655
TheresAlwaysAWay
TheresAlwaysAWay
Bennie47250
  • Locked
  • Question
Report Crashes
Replies
2
Views
106
kray4660
kray4660
ameedoo3000
  • Locked
  • Question
format partition by vba code
Replies
6
Views
384
mattKnight
mattKnight
Moss100
  • Locked
  • Question
Create a Report from a query and then personalise the report for each client - possible?
Replies
2
Views
100
dhookom
dhookom
LondonJohn
  • Locked
  • Question
Problem using Access 2003 and 2007 for the same database
Replies
4
Views
252
LondonJohn
LondonJohn

Part and Inventory Search

Sponsor

Back
Top