Can I assign an unbound field in a report to more than one control source? If so how and how does it know where to pull from. Here's what I have. I have a form that I enter data into table A. On the form I want to be able to populate a report with the information from that form...this one I have covered. What I want to do is use that same report and have the same fields be populated based on a query also. So, Field X on the report could be populated from Form A or from Form B, w/o having to create two different reports.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Binding a Report Field to more than one source
- Thread starter crash180
- Start date
hermanlaksko
Programmer
Give your report the recordset you want to use and on the reports details section insert in the "OnPrint" event FieldX=re!YrFld
As I understand you your fiels is unbound as such it has no control source.
If you are useing a control source on your FieldX make sure that your 2 recordsources uses the same field names.
Herman
Say no to macros
As I understand you your fiels is unbound as such it has no control source.
If you are useing a control source on your FieldX make sure that your 2 recordsources uses the same field names.
Herman
Say no to macros
- Status
Similar threads
- Locked
- Question
- Locked
- Question