Expression on report.

[Perfac]

I created a table t01BusinessInfo with field BusinessName. Query is q01BusinessInfo and report r01BusinessInfo and form f01BusinessInfo. There is also a report r01Customer. In the pageheader of report r01Customer I added a text field. What expression will return the contents of form f01BusinessInfo text fieldname T001 to text field in r01Customer? I.E. =[Forms]![f01BusinessInfo]![T001]

[Minty]

Are you trying to restrict the report to only show the current customer selected in the form?

If so use the reports recordsource query and put the form reference in the criteria for the customer name/ID in the query
Moving forwards I would rename your form controls to something more memorable e.g. [Forms]![f01BusinessInfo]![txtCustomerName]

I'm also not sure that using 01 etc in your naming convention is going to help you in the long run. But at least you have a naming convention so perhaps I should shut up

[Perfac]

Hi, thank you. I am Hans from South Africa. Used a lot of time in 2016 on Access. No time used in 2017. Quite proud of my development though. I thought this issue should be simple. I created a table which keeps only one business info, my business. For the purpose of being able to return the info to reports like invoices or any other reports. I achieved that through query and joining the BusinessInfo table and Invoice Table. I still wonder if there is an expression though. In the page header can one add a text field an have an expression that return the info in the field of table BusinessInfo.

[Minty]

You can use a DLookup in the report if it just one record in the business table.
DLookup("BusinessName","t01BusinessInfo") would get you the name straight out of the table.

Or you can simply add the table - without a join - and refer to that field, this will cause a Cartesian join, which may slow down things if there are lots of records.

[Perfac]

Great. It worked. In 2016 I posted this request, and never got a reply that worked. Thanks.