Hello Access World I hope you can help me!
I am new to VBA and want to have one command button execute multiple commands. I wont bore you with all of the code I have but basically what I want to happen is this.
Click Button
Execute If Statement 1
Then
Execute If Statement 2
etc...
I don't want ElseIF statements because I want the first statement to run and if false to simply jump to the next statement. However, even if one statement turns out to be true I still want it to process the subsequent ones. I don't want it to simply stop the first time if gets to a statement that is true and ignore the rest.
Does this make sense?
Thanks!!!
Kev.
I am new to VBA and want to have one command button execute multiple commands. I wont bore you with all of the code I have but basically what I want to happen is this.
Click Button
Execute If Statement 1
Then
Execute If Statement 2
etc...
I don't want ElseIF statements because I want the first statement to run and if false to simply jump to the next statement. However, even if one statement turns out to be true I still want it to process the subsequent ones. I don't want it to simply stop the first time if gets to a statement that is true and ignore the rest.
Does this make sense?
Thanks!!!
Kev.