If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pass infomration from a form to a report...
I have a form that displays a certain fields from a specific record. How
can the selected values be passed to create a report? From my understanding reports can only get information from tables and queries. How can I query th information from a form? Thank you for any help, George |
#2
|
|||
|
|||
Pass infomration from a form to a report...
On Fri, 26 Mar 2010 12:13:31 -0400, George
wrote: I have a form that displays a certain fields from a specific record. How can the selected values be passed to create a report? From my understanding reports can only get information from tables and queries. How can I query th information from a form? Thank you for any help, George Well, actually you can. For instance you can base the Report on a Query with a criterion =[Forms]![NameOfYourForm]![NameOfSomeControl] to use that control's value as a criterion to select which record or records to include in the report. You can use the same expression as the Control Source of a textbox on the report if you just want to display the value of an unbound textbox. -- John W. Vinson [MVP] |
Thread Tools | |
Display Modes | |
|
|