Error in Text box

[jband]

I created a report that uses a text box that has the following formula in it

="Office/OutPatient (" & [Catagory] & ")"

This formula worked until I added a subreport. The subreport uses the same but with a slight difference

="Office/OutPatient (" & [Cat] & ")"

.

How do I get rid of the error so that the text box functions properly?

 

[RuralGuy]

What error do you get and where are the [Cat] and [Category] controls or fields located?

 

[jband]

I get #Error and #Type!

The [Catagory] is located in main report in detail section and [Cat] is located in the same section in the subreport

 

[RuralGuy]

I usually name a control txtControlName to separate it from the field to which it is bound. Access can get confused sometimes. You also need to "pull" (bind) the fields of the RecordSource to a control on a report (which can be invisible) in order to reference the value.

 

[jband]

That worked. It pulled in the catagory corectly in both the main report and the sub report. Thank you

 

[RuralGuy]

Excellent! Glad we could help.