Filter a Report with from a Form

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups Forms Forms Programming Queries Modules / DAO / VBA Reports / Printing Macros Database Design Security Conversion Importing / Linking SQL Server / ADP Multiuser / Networking Replication Setup / Configuration Developer Toolkits ActiveX Controls New Users General 1 General 2

Access Directory Tools Tutorials User Groups

Related Topics

SQL Server Other DB Products MS Office More Topics ...

MS Access Forum / Forms Programming / April 2006

Filter a Report with from a Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gary Hull - 30 Apr 2006 14:33 GMT

I would like to be able to use a combo box on a form to filter a report

Thanks
Gary

Reply to this Message

Duane Hookom - 30 Apr 2006 16:54 GMT

Set the criteria in your query (report's record source) to something like:

[Forms]![frmYourFormName]![cboYourComboName]

The form must be open prior to opening your report.

Signature

Duane Hookom
MS Access MVP

>I would like to be able to use a combo box on a form to filter a report
>
> Thanks
> Gary

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

My Homepage

Start New Thread

Enable EMail Alerts

Rate this Thread

©2008 Advenet LLC Privacy Policy - Terms of Use

This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.