I have an Access macro that runs a query. This macro functions fine in Access. I would like to run it in an Excel macro (I've very little vba knowledge and clipped what I could online). The macro I have in Excel consists of a userform that runs my Access macro/query when the user clicks a button- it requests the parameters, but then no results are displayed (the same macro produces a data table in access). I don't know if I need to add something to my Access macro or to the Excel macro to fix this, but the access guys told me it's an excel thing. Here is what I have on the Excel macro:

Sub TrackingMultiple()
Dim A As Object
Application.DisplayAlerts = False
Set A = CreateObject("Access.Application")
A.Visible = False
A.OpenCurrentDatabase ("P:\equityShared\rw\sales\Structured Equity Solutions\Institutional Coverage\Business Planning\Tracking.mdb")
A.DoCmd****nMacro "SearchMultipleFields"
Application.DisplayAlerts = True
End Sub

Any help would be much appreciated!

One thread per question please, Sweetie.
If anyone would like to help, please do so here:
Trouble displaying Access query results from Excel macro

pootle flump ur codings are working excelent.