Help!!!

[TheStriker]

I have a report that contains a subreport and I figured out how to test each record in the subreport but I need to test several fields with one block of code because there is only one event that will call the procedure (OnFormat). Is there anyway to nest multiple If..Then..Else statements or looped If statements that allow me to acheive this? I probably could figure it out on a good day but I need to finish this today. Any help would be greatly appeciated.

Thanks

 

[dhookom]

Could you provide a simple sample of your data and what you want to do? I have no idea what you mean by "test several fields".
You can use all kinds of expressions and loops and stuff in code.

Duane
MS Access MVP

 

[TheStriker]

Nevermind, I decided to go without it. Thanks anyway though