Another way to Refresh

[Burt Rosner]

To Anyone That Can Help,

Is there another way to refresh a listbox or table
without using the DoCmd.Refresh command

I think the DoCmd.Refresh statement is taking to long. I
am looking for a way to speed up the loading and
refreshing of some forms.

Thanks for any advise,

Burt

 

[Arvin Meyer]

You can try requerying the listbox:

Me.lstMyListBox.Requery
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Burt Rosner]

Arvin,

When I said refresh, I meant requery. I believe the
requery macro slows the process down. I was wondering if
there is code I could use instead of the requery
statement.

Burt

 

[jose ferrero aldea]

Arvin,

When I said refresh, I meant requery. I believe the
requery macro slows the process down. I was wondering if
there is code I could use instead of the requery
statement.

Burt