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
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