So ive been working at this DB for a few weeks now. I have the report i want just about finished up, but im having a slight issue.
I have a report based off "qryItems for Job transfers". This query populates from a given value in a form "[form]![switchboard]![reportdate]". In that report i have a list box rowsource "qrycost after tax for 506/507", which is based off of "qryItems for Job transfers".
The report is setup like this:
group on Job Number (tax status)
group on Class (material, quantity, unit price)
The report returns the cost for each class for each job number. The text box mentioned above sums all groups based on class. Prior to adding the text box when i hit print it used the report date value to determine what to print. NOw i am recieving a popup "[form]![switchboard]![reportdate]".