Send filtered result to existing report

  • Thread starter Thread starter John Bartley K7AAY
  • Start date Start date
J

John Bartley K7AAY

I have designed three reports to draw from a single table, tblClips.

Now, I want to be able to filter the records in tblClips on one or
more field contents, not predetermined, and send the result to those
three predefined formatted reports. I don't see how I can do that.

I have a small amount of macro and VBA code experience over the past
month, not much.

Your kind assistance would be greatly appreciated, especially given I
have searched here, in comp.databases.ms-access and multiple websites
for how to do this.

Thank you kindly.
 
Hi John,

Try this sample:
Query By Form
Tom Wickerath, January 8, 2008

available here: http://www.seattleaccess.org/downloads.htm

This is a fairly easy method that involves very little VBA code. After you
are more comfortable with VBA code, and ready to try out a more complex
sample, head on over to Access MVP Armen Stein's site and grab a copy of his
Report Selection Techniques sample, available here:

http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
 
Back
Top