I wish to open an access report which extracts data from a table based on a filter query launched by VBA in Excel.

I have been trying DoCmd.OpenReport "Report Name",acViewNormal,"Query Name" but all that happens is that Access opens and sits at the query. The report does not open and the filter "Enter" boxes do not appear.

I would be most grateful for some help.

Graham Terry