A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Pass infomration from a form to a report...



 
 
Thread Tools Display Modes
  #1  
Old March 26th, 2010, 05:13 PM posted to microsoft.public.access.gettingstarted
George[_7_]
external usenet poster
 
Posts: 22
Default 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  
Old March 26th, 2010, 05:54 PM posted to microsoft.public.access.gettingstarted
John W. Vinson
external usenet poster
 
Posts: 18,261
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:46 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.