Dynamic datasources for forms and reports

[mazza]

Was wondering if you could can set a data source for a form or report programatically based upon the certain criteria , which cannot be captured in 1 query

for example
if my criteria is a date range in Form A
then open Form/Report B using query A
if ny criteria is to filter on a customer in Form A then
open Form/Report B using Query B etc etc

What code would I use and what event to use (OnOpen, OnLoad, OnCurrent ???)

thanks

 

[MStef]

Hello mazza!

Look at "DemoDinamycDataSoA2000.mdb".
Look at Table, Forms, Report, Querys.
Open Form_A and try.