Simple report problem

[Gary Thompson]

Using VB, I run a query in Access, and then show a VB Report using the query
results.
(The query makes a new table each time it is run.) Inside access, the data
is correct.
The VB report is correct THE FIRST TIME I RUN IT. If I ask for the report
on a differtent PO#,
I get the original PO data, not the new one. This has got to be something
realyy simple, I
just don't see it.

Code:
Private Sub mnuPrintPO_Click()
Dim ac As Access.Application
Set ac = New Access.Application

DoEvents
ac.OpenCurrentDatabase ("c:\abstract\abstract.mdb")
ac.DoCmd.OpenQuery "qryMakeSinglePO"
DoEvents

drSinglePO.Refresh
drSinglePO.Show
ac.CloseCurrentDatabase
DoEvents
Set ac = Nothing
End Sub

[Phil Weber]

> Using VB, I run a query in Access, and then show a VB
> report using the query results...The VB report is correct
> the first time I run it. If I ask for the report on a different
> PO#, I get the original PO data, not the new one.

Gary: If you don't get an answer here, you might try reposting your question
to our vb.vba newsgroup. Thanks!
---
Phil Weber
DevX.com, Inc.