[AccessD] Interesting run time error

John, what event are you using to populate the combo? Does this happen with 
Form Load and Form open?

Why is the SQL statement invalid? When building it, couldn't you check it 
before setting the combo?

Susan H.


> When a combo is assigned an invalid sql string, perhaps a select from a
> non-existent table or a OrderBy clause on a non-existent field, there is 
> not
> error until you try to drop down or otherwise use the combo.  The error 
> pops
> out of the depths of Access and AFAICT cannot be trapped.