Strange Run Time Error

[gemma-the-husky]

this single line of code has been working fine for ages in various versions of Access, but has just thrown an error in Access 2002

subroutes.Form.OrderByOn = False

subroutes is the name of a subform control on a main form.

Could this be an installation issue on the particular terminal? Any thoughts?


I have added an on error resume next, so it should be OK now, but I cant understand whats caused this.

 

[KenHigg]

Maybe you just need to plug in the main form name:

forms!mymainformname!subroutes.Form.OrderByOn = False

???

 

[Darth Vodka]

what's the error?

 

[gemma-the-husky]

i couldnt reproduce the error - i didnt have an error handler for that line, and it just jumped to the active error handler, so it looked like a different error. A client had the error, but only on one out of several machines.

ive added a "on error resume next", to dismiss it, as its not the end of the world

 

[boblarson]

Just a reminder that it could be a reference problem. I would check for that and if there is no missing reference, then uncheck the ADO / DAO reference (whatever is checked) and close the dialog and then recheck it.