Form to choose combo boxes for printing (1 Viewer)

[access2010]

Hello we use MS Access 2003 and would like to print a report by choosing data from two combo boxes on the form

1 - Fiscal Year
2 - Fiscal Month
3 - Preview the report and than print

Your assistance will be appreciated

Susan

 

[Ranman256]

cboMo, and cboYr sit on a form: frmRpt
the query in the report will look here...

select * from table where [fiscMo]= forms!frmRpt!cboMo and [fiscYr]= forms!frmRpt!cboYr

 

[jdraw]

see these free tutorials
http://www.datapigtechnologies.com/flashfiles/combobox1.html
http://www.datapigtechnologies.com/flashfiles/combobox2.html