Error on Click of command button (1 Viewer)

[syedadnan]

i have sometimes getting error on on click event of a command button to open a form, and sometimes it works ok i have written the code like this;

me.refresh
docmd.openform... so on

whats wrong here as this works fine sometime and sometime error saying the "on click event of the ..... produce error .. so on"

whats wrong here

 

[Minty]

Without seeing the actual error, and the actual code behind the form button we will all be guessing.

I would stab in the dark with my eyes closed and all the lights off, that it's to do with underlying data or the lack of it on the form you are on or similar on the form you are trying to open.

 

[syedadnan]

Without seeing the actual error, and the actual code behind the form button we will all be guessing.

I would stab in the dark with my eyes closed and all the lights off, that it's to do with underlying data or the lack of it on the form you are on or similar on the form you are trying to open.

ok i will post you once it again happen