DoCmd Sometimes does not appear to work

  • Thread starter Thread starter Michael Hudston
  • Start date Start date
M

Michael Hudston

I have a very strange symptom occuring. I am developing and testing a Client
Management Database, and for some reason. One of the "DoCmd.Openform" lines
I am using does not appear to work, when placed the Front End database, is
installed on to the machine that it will be running on.

It works ok, on the test bed Its a simple command

DoCmd.OpenForm "RMA Details", , , , acFormAdd

I use similar commands throughout the database on several switchboards, and
these all work ok.

Is there something simple I am missing? I think I have checked all the
permissions and settings for Macro's etc so they are the same from the Test
bed to the live machine, but still to no avail.

Help
 
That doesnt appear to be the issue as there is no on open or on load event on
the target form.

The only event is afterupate which is a me.refresh
 
This is now one of two forms that does not open. Both are using the
DoCMd.OpenForm to open them, no special arguments are being used and other
forms are using similar commands to open forms from the switch board.

Yet the very same database works on the Test Bed. This makes me think it is
a permissions issue or something to do with the set up of access on the live
machine.
 
I think Alex has covered everything, but one possibility that came to mind
to double-check: there isn't something that's silently cancelling the Open
Form, is there (i.e., setting the Cancel value in Form_Open)? Maybe
something that doesn't happen on the test bed due to the specific records
you're opening or something to that effect?

Just a thought.



Rob
 
Well, I have now got it to work, although I still do not know what the
origional problem was.

I deleted the button and used the button wizard re-create the code, which
then I copied and pasted on to my own button event procedure.

The only difference I an tell between the DoCmd.Openform commands is that
the izard used Null values between quotes "" in the command line, where as I
have not.
 
Back
Top