Invalid procedure call error

[aman1234]

Hi All

I'm declaring a global variable and getting the above error message

Please Login or Register  to view this content.

Any help will be much appreciated.

Thanks

[LJMetzger]

Hi aman1234,

It seems like you did not declare a Sub or Function. Your code should probably look something like:

Please Login or Register  to view this content.

The above code compiles fine with a value of '(TO>#12/01/2015# or TO IS null)'.

Option Explicit is very important
It is a best practice to declare all variables. If you misspell a variable in your code, VBA will silently assume it is a Variant variable and go on executing with no clue to you that you have a bug. Go to the VBA development window, click Tools, Options, and check "Require Variable Declaration." This will insert the following line at the top of all new modules:

Please Login or Register  to view this content.

This option requires all variables to be declared and will give a compiler error for undeclared variables.

Lewis

[Kyle123]

The sql1 = ... line must be in a sub

[aman1234]

I need to use the value of sql1 many times in the code so that's why I want to define it globally so that I can use it as many times as I want . please see below:

Please Login or Register  to view this content.

Im getting invalid outside procedure error. Any help will be much appreciated.

[Kyle123]

It must go in a sub, just make sure the sub runs before all your other code

[aman1234]

kyle123, so how can I use the value of sql1 in combobox1_change() event?

[LJMetzger]

Try something like:

Please Login or Register  to view this content.