Procedure too large?

[tjewers]

Hi,

I am getting the "Procedure too large" error in a search form that I am creating. I know this is because my procedure is way to big. I was wondering if anyone can give me hints on how to break up the code, but still use it in the command button.

Basically the code is a number of if else statements. Is there some way to put each if else statement in a procedure and use them in the procedure for the command button?

Any and all help is appreciated.

Tracy

 

[Neal]

Have you tried a Case statement? I think they are less demanding on system resources than If/else.