Field on a form appearing on a report

[AmyLynnHill]

I have a form with three fields on it, Two of the field are used to match fields on a query to pull information from a datawarehouse then run a report. The third field is a field I want to populate on the report but is not in the Datawarehouse.
How do you put a field on a query that does not exist in the tables used but is a keyed into the form?

 

[rainman89]

if you have the form open at the time the report is opened you can make a txt box on your report and set its source to

=forms!formname.txtboxname

 

[AmyLynnHill]

I do this in the control source property of the report correct?
I did this and it is giving me a prompt for FORM?

 

[manix]

I do this in the control source property of the report correct?
I did this and it is giving me a prompt for FORM?

Is the form open? If it is not open and active then it will ask for the information manually

 

[rainman89]

I do this in the control source property of the report correct?
I did this and it is giving me a prompt for FORM?

not the control source for the report.

for the txt box on the report where you want the information to show

 

[AmyLynnHill]

I put it in the control source of the text box. The form is open and has a button to run the Macro/query which generates the report.

When the prompt comes up "form" if you select ok, the report generates and #NAME? is in the field.

 

[rainman89]

whats the exact code you are putting the control source of the txtbox?

 

[AmyLynnHill]

=Form!frmInputPolNumFA2.Text34. Text34 is the field on the form. this is in the control source of the textbox on the report.
Thank you so much for your help, this is very trying.

 

[rainman89]

you have a typo

should be

=forms!frmInputPolNumFA2.Text34

 

[AmyLynnHill]

YOU ROCK! Sorrry for the stupidity. This is a major breakthrough for this novice. Thank you so much!

 

[rainman89]

Glad to help!!

 

[rainman89]

for future reference. check this out.