Access 2003, Open qdf in Query Window ?

M

Mike Thomas

When I want to open a query in the query window, I usually use
docmd.openquery("Inventory")

Is there a way to open a query window using a qdf object ?

For example, in the code below, is there a command to open the 'Inventory"
query in a query window?


Set qdf = db.QueryDefs("Inventory")
If lngKey = 0 Then
qdf.Parameters(0) = 0
qdf.Parameters(1) = 0
Else
qdf.Parameters(0) = lngKey
qdf.Parameters(1) = 1000
End If
????????

Many thanks
Mike Thomas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top