sql hangs
 

Sounds like you need Application.ScreenUpdating set to True.
--
Jim Cone
Portland, Oregon USA



"Richard Douglass"

wrote in message
I am writing some code that runs in a form to get records from a sql
database. The recordset comes back clean and has the records I expected and
the sheet gets the command to populate but then nothing happens.

When I kill the VBA form the sheet refreshes with the data. before I kill
it the form is in hung mode. when I drag it around it leaves a trail.

any ideas?