Hi This is an annoying problem that i havent encountered before; A form
that I have done a lot of work on has lost its show method so when I
use fromname.show on a worksheet button I get "run-time error '438'
Object doesn't support this property or method"

I've tried copying the forms objects and code onto a new form...that
works until I run procedures behind the form and then the method
disappears and I'm back to square one again.

Any help on this would be gratefully recieved. Thanks Richard

"itjunkey" wrote in message
oups.com...
Hi This is an annoying problem that i havent encountered before; A form
that I have done a lot of work on has lost its show method so when I
use fromname.show on a worksheet button I get "run-time error '438'
Object doesn't support this property or method"

I've tried copying the forms objects and code onto a new form...that
works until I run procedures behind the form and then the method
disappears and I'm back to square one again.

Any help on this would be gratefully recieved. Thanks Richard


Kind of solved this one myself by discovering that the formname.show method
is still available for this form in module so i created a procedure to show
the form in a module and called that procedure from a button on a
worksheet....but why does the show method work for other forms from buttons
on the worksheet ? I dont know :(