Apologies if I haen't got this in the right section, as it kinda covers both Excel and Access.

Anyway, I have an Excel app which uses a UserForm to store data into an Access database. The Userform simulates an existing paper form. So, I have set up a query in Access to pull out the specific fields and I then used this query to create an Access Report.

What I want to do is to be able to use VBA behind a cmmand button from the Excel UserForm to be able to run and view the report.

I've found various topics on it but none seem to really eith work for me or give me what I need.

Any help really appreciated, as I was due to demo this tomorrow ! but I have extended my deadline til Friday ....