Statement Woes (1 Viewer)

[KevlarKev]

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.

 

[Cotty42]

Seems like a fairly simple case of consecutive If statements,
i.e.

If this is true then
Do this
End If

If that is true then
Do that
End If

etc.

Hope this helps

Dave

 

[KevlarKev]

THANK YOU VERY MUCH!

No idea why I didn't think of that. Works a treat!!!