problem with source file/form

  • Thread starter Thread starter TM
  • Start date Start date
T

TM

I am sure this is really simple. I have a report which
will be opened from a form. The source query on the
report references a text box on the form where the id
field is located. When I try to open the report, it asks
for the id... why would it not just "look" at the form.
In the query the condition reads: "forms![frmMarketing
Mindset]![MindsetID]". So, the report is supposed to
pick the corresponding data from the table which matches
the id field on the form. The form is open and the
record has been saved to the appropriate table... so, why
can/does it not just reference that text box?
 
TM said:
I am sure this is really simple. I have a report which
will be opened from a form. The source query on the
report references a text box on the form where the id
field is located. When I try to open the report, it asks
for the id... why would it not just "look" at the form.
In the query the condition reads: "forms![frmMarketing
Mindset]![MindsetID]". So, the report is supposed to
pick the corresponding data from the table which matches
the id field on the form. The form is open and the
record has been saved to the appropriate table... so, why
can/does it not just reference that text box?
Click to expand...


This is caused by your spelling something differently on the
form or in the condition. Check for extra or missing
spaces, etc. too. Maybe the condition is enclosed in
quotes, if so, get rid of them.
 
Yes, you were right, I just retyped it... thanks!
-----Original Message-----
TM said:
I am sure this is really simple. I have a report which
will be opened from a form. The source query on the
report references a text box on the form where the id
field is located. When I try to open the report, it asks
for the id... why would it not just "look" at the form.
In the query the condition reads: "forms![frmMarketing
Mindset]![MindsetID]". So, the report is supposed to
pick the corresponding data from the table which matches
the id field on the form. The form is open and the
record has been saved to the appropriate table... so, why
can/does it not just reference that text box?
Click to expand...


This is caused by your spelling something differently on the
form or in the condition. Check for extra or missing
spaces, etc. too. Maybe the condition is enclosed in
quotes, if so, get rid of them.
Click to expand...
 
Back
Top