Error 5: Invalid Procedure call or argument

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sara Sun - 01 Jun 2007 18:30 GMT

I created 2 forms, one being a dialog box and when a value is selected & user
clicks OK, then the second form opens up with results. It has a macro running
on the back end. I developed these forms in the desktop copy of my database
and the forms run fine without any error. But when i exported the 2 forms and
this macro to the live version & tried to operate the forms, I am getting an
error message "Error 5: Invalid Procedure call or argument in Form Load". I
double checked the program and double checked the VB codes and backend
Macros, everything seem to be fine. Except that i am getting this error in
the live version.

Any Ideas ?

Reply to this Message

Maurice - 01 Jun 2007 18:45 GMT

And can you tell us what this macro is supposed to do? meaning what is your
macro call?

Signature

Maurice Ausum

> I created 2 forms, one being a dialog box and when a value is selected & user
> clicks OK, then the second form opens up with results. It has a macro running
[quoted text clipped - 7 lines]
>
> Any Ideas ?

Reply to this Message

Sara Sun - 01 Jun 2007 19:20 GMT

macro is suppose to set value from the dropdown in the dialog box to
recordsource of the opening form. Problem is not with my macro. It works
perfectly fine in my copy and I created a dummy database with these forms -
the forms work in the dummy database. it doesnt work in my live copy.

> And can you tell us what this macro is supposed to do? meaning what is your
> macro call?
[quoted text clipped - 10 lines]
> >
> > Any Ideas ?

Reply to this Message