?
Solved

How to set a control source on an Access Report to a form field?

Posted on 2011-10-31
2
Medium Priority
?
269 Views
Last Modified: 2012-05-12
Hi everyone,

I'm trying to set the control source of a text box on an Access Report to a field on a form that I've created.  I can't remember the exact syntax used to allow the field on the form to be referenced.

Can someone please refresh my memory?

Thanks.  
0
Comment
Question by:Anthony6890
2 Comments
 
LVL 49

Accepted Solution

by:
Dale Fye earned 2000 total points
ID: 37056760
=Forms!FormName.ControlName
0
 
LVL 1

Author Comment

by:Anthony6890
ID: 37056807
Ah, thanks!
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question