Just wondering how the heck you populate the parameter dialog in an Access
2000 database when you are trying to use automation.

Desperate... this is what I have so far.

Dim objAccess As Object
Set objAccess = CreateObject("Access.Application")

objAccess.UserControl = True

objAccess.OpenCurrentDatabase _ filepath:= "\\Voyager\SpruceConnect\SpecialOrder.mdb"

objAccess.DoCmd.OpenQuery("CO Margin Lookup")