Hi,
What is the simplest way of populating a label on a report? I want each page of the report to be a different job no?
cheers for any help.
Hi,
What is the simplest way of populating a label on a report? I want each page of the report to be a different job no?
cheers for any help.
What exactly do you mean by 'populating a label on a report'? Do you have a table with field for job no?
Provide sample data. If you want to provide db for analysis, follow instructions at bottom of my post.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Hi thanks for reply and I haven’t created the database yet and I’m not to experienced with access but searching around I think the term i am looking for is a dynamic report title so I should be able to sort that.
Presuming the job number is in the data, just use a textbox instead of a label and put the job number field in the control source.
That’s great will give it a try, cheers
No problem, post back if you get stuck.
Hi I tried that today but just kept giving me a number. I have the job no in a separate table from the one I generated the form. I am sure it was the ID it was giving me as it changed from 1 to 2 to 3 as I went thru the first three jobs.
i got over it by adding code to the ID text box so each time it gets focus it grabs the value of the job no, job name and item reference and puts it in the text box in the form. Probably long winded way of doing it but more familiar with vba than access.
Original question was about a report. Why do you reference a form in your solution?
Why don't you build query that joins tables for report? Then related data is available. This is what I think Paul meant.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.