print a report using data from a form and not a table

[ToniS]

I have a form called QuickBadges that allows the user to enter in First Name,
Last Name and Company Name, Once the user clicks on a button a report will be
ran to print a label. In this senerio, the data is not stored in a table. In
most cases the reports/labels that I have created I add a select statement
with in the reports record source. In this example I left it blank. How can
I get access to print
a label for me for data that is not stored in a table but is on a form?

My application is an .adp and I am using Access 2003.

Any suggestions would be Greatly Appreciated
Tonis

 

[Allen Browne]

If the form is named Form1, and has a text box named LastName, you could use
this in the Control Source of the text box on your report:

=[Forms].[Form1].[LastName]

 

[ToniS]

Thanks!!!

If the form is named Form1, and has a text box named LastName, you could use
this in the Control Source of the text box on your report:

=[Forms].[Form1].[LastName]

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have a form called QuickBadges that allows the user to enter in First
Name,
Last Name and Company Name, Once the user clicks on a button a report will
be
ran to print a label. In this senerio, the data is not stored in a table.
In
most cases the reports/labels that I have created I add a select statement
with in the reports record source. In this example I left it blank. How
can
I get access to print
a label for me for data that is not stored in a table but is on a form?

My application is an .adp and I am using Access 2003.

Any suggestions would be Greatly Appreciated
Tonis