VBA Report control

M

meyvn77

I have a project using crash data where I would like a form to promp
the user for 1 of the 8 stock report from a pulldown box with options A
through E and a 'From' date and 'To' date. The options would be like
crashes involving Fatalities, or Injury crashes, or Pedestrian
crash...ect.. So each 1 of the 8 stock reports could have many
variables.. I would like to know if I can use the control source or how
I would go about programmicly in VBA setting the report source...

like....
Report.source =
(Select * from Events
where Events.Date between(" & Date1 & "," & Date2 & ")
AND INJURY(or some other field) = " & Injury & ")

Can you do this? Any help or a link to some documentation would be
great.....

Chuck
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Default dates in parameter values 4
Top values report 5
Lapsed Time when 1 date is null 2
Locked VBA causes Access to crash with ACCDE files 1
Open report from multivalue fields 1
Excel Excel 2013 - Control/sync multiple slicer timelines from one slicer timeline 0
Cascading combo boxes - are they able to do this? 6
Problem getting dependency information from a query using VBA 1

Top