access 07 Report Prints Form first time instead of Report

[sailinxtc]

access 07 Report Prints Form first time instead of Report. If I print again it prints Report fine from then on. Using a macro to call the query, and don't think its the query since it only happens the first time. Didn't find anyone with similar issue

 

[TheAceMan1]

How are ya sailinxtc . . .

If your printing or previewing a report, why are you calling a query? ... Should'nt you be [blue]opening a report?[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[sailinxtc]

The query is used to show the current record, it does open a report and looks fine, however when I print the very first time with the report open it prints what the form looks like, if I print again, it prints the report from then on.

 

[dhookom]

sailinxtc,
Please share your code or method for printing. None of us can see your computer screen.

Duane
Hook'D on Access
MS Access MVP

 

[sailinxtc]

Here is the query that is called from a button for the current record being viewed from the form.

SELECT TTLOG.[Log ID], TTLOG.Date, TTLOG.[First Name], TTLOG.[Last Name], TTLOG.[Title Name]
FROM TTLOG
WHERE (((TTLOG.[Log ID])=[Forms]![TTLOG]![Log ID]));

Macro: I have two actions, the first is select object - object type is query, object name is Current Log ID, in database window yes. The second action is: open report, report name TTLog3, View Print Preview, window mode Normal

 

[dhookom]

Take the hint from TheAceMan1 and don't open the query.

Duane
Hook'D on Access
MS Access MVP