Hi All,
Great site, this is my first post.
I know it is wrong to use forms to print data but in this case I cannot use a report as I am print charts on a form.
Basically I have a chart on a form which is linked to the forms record source via the “Link Child Fields” & “Link Master Fields”. This works fine when moving through the records on the form with the charts data staying synchronised.
This is not the case when I go to print the form & relevant records. In Print Preview the first record appears as it should but after that the chart goes blank for the remaining records. I believe this is due to the “Linked Field” not being updated in this mode.
I have found a work around by filtering the current record bound to the form & calling Print Preview. The only problem is I can't seem to tell when the form has been printed or the user has closed the print preview & returned to the form. This is a problem as the form is filtered & I need to remove this filter & move back to the printed record & to allow the user to move through all the records.
**I need the chart on a form as I have investigated putting it on a report but you have limited control over the chart on a report, ie change chart data source, title etc. As the project requires in excess of 50 charts using a form & hopefully one chart I will save time & space.
Regards,
Adam.
Access 2003.
Great site, this is my first post.
I know it is wrong to use forms to print data but in this case I cannot use a report as I am print charts on a form.
Basically I have a chart on a form which is linked to the forms record source via the “Link Child Fields” & “Link Master Fields”. This works fine when moving through the records on the form with the charts data staying synchronised.
This is not the case when I go to print the form & relevant records. In Print Preview the first record appears as it should but after that the chart goes blank for the remaining records. I believe this is due to the “Linked Field” not being updated in this mode.
I have found a work around by filtering the current record bound to the form & calling Print Preview. The only problem is I can't seem to tell when the form has been printed or the user has closed the print preview & returned to the form. This is a problem as the form is filtered & I need to remove this filter & move back to the printed record & to allow the user to move through all the records.
**I need the chart on a form as I have investigated putting it on a report but you have limited control over the chart on a report, ie change chart data source, title etc. As the project requires in excess of 50 charts using a form & hopefully one chart I will save time & space.
Regards,
Adam.
Access 2003.
