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