Error accessing file. Network Connection may have been lost

[hkbana]

Please help

I am developing an access database, but I have encountered a problem which I have never seen. when I open the database and open a form I get the following error

"The expression On Click you entered as the event property setting produced the following error: Error accessing file. Network Connection may have been lost."

Please help me on how I can resolve this.

 

[Autoeng]

Post the code behind the button please.

Autoeng

 

[hkbana]

Its simple code

The code is as follows.

docmd.openreport "rptDispenserReport", acpreview

when I use a macro to open the report it seems to be ok.
but then I get other problems

I have a feeling that there is something wrong when I am writing code, but I cannot figure out what. Maybe a bug or something's wrong with the references I dont know.


Please help.

 

[Autoeng]

I don't think that it is references. Delete the button and make a new one to do the same thing. Before creating the new button delete the old code. After the new button has been created make sure your code is compiled.

You say if you open the report via macro you get other problems. What are they? Is there code in the report?

Autoeng

 

[hkbana]

other probs

when i use a macro then the report starts to open, but then as the underlying query has criteria which it sources from a form it does not like that even if I have data in the fields on the form when the macro opens the report it still asks me for the the data which is already on the form.

Please help.