Say, I have found that to be a problem in the past as well. Access XP (2002) doesn't want to recognize the .Type method, that is, a statement like this always fails:
if form.controls(i).type = acComboBox
I get around it by placing a unique string in my controls of interest .Tag property and do use a loop, but I use the .Tag property instead of the .Type property to pinpoint my controls.
Why does Access XP not accept the .Type method?
Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
|