Problem getting user facility address on reports

[thatlemhome]

I have a database that I want to push out to multiple users. I have a series of canned reports where I want the users default address to print on the report.

I have defined a form (sort of a system setup form) for the user to enter their facility address and bmp company logo. (only one entry per application). Currently this is linked to a table, but doesn't need to be.

form: frms_Default_Facility
table: tbl_Default_Facility

fields: Facility Name
Facility Address
Facility City State Zip
Facility Logo

The only way that I have been able to get the fields to display is if I link them into the query running the report. It worked great, however, this places the same information on each line of data, and could get unmanageably large if a logo is added.

I think that I should be able to simply link these fields by using an unbound field and then defining the source, but only get ?Name error. I have tried some basic code, but am not familiar with VBA to a large extent.

Does anyone have any ideas? Thanks.

 

[boblarson]

Just create a subreport for that information and add it where you want it (probably in the report header).

 

[thatlemhome]

thanks, hadn't thought of that....too easy.
works like a charm