Error 5: Invalid Procedure call or argument

[Sara Sun]

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 ?

 

[Maurice]

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

 

[Sara Sun]

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.