VB6 Report update problem

[Red Hammer]

Hi, I have a report that I used the data designer to create and what happens
is that it does not update until the application is closed and opened again.
For example, you can enter a new record and then open the report and it will
not show the new record until the application is closed and started up
again. Anybody got any ideas how I can make the report update immediately?

Thanks for any help you can give.

Weblog: http://decentre.blogspot.com

[Svend Erik Johansen]

Re: VB6 Report update problem

Hi

Try to open the recordset and close it again BEFORE you run the report.

Dim myset as Recordset
StrSql="Select * from ... ;"
Set myset = mydb.OprenRecor dset(StrSql,dbO penSnapshot,dbR eadOnly)
myset.close
set myset = Nothing

Svend
DK

"Red Hammer" <chris.brazenda leREMOVE@inspir e.net.nz> skrev i en meddelelse
news:43922d63@c lear.net.nz...[color=blue]
> Hi, I have a report that I used the data designer to create and what[/color]
happens[color=blue]
> is that it does not update until the application is closed and opened[/color]
again.[color=blue]
> For example, you can enter a new record and then open the report and it[/color]
will[color=blue]
> not show the new record until the application is closed and started up
> again. Anybody got any ideas how I can make the report update immediately?
>
> Thanks for any help you can give.
>
> Weblog: http://decentre.blogspot.com
>
>[/color]