Ricardo has attended:
Access VBA course
Access Advanced course
Multi user database
Can multiple IIF statements in a form significantly slow the form down?
Thanks
Ricardo
RE: Multi user database
The simple answer is No.
Regards
Carlos
RE: Multi user database
Thanks Carlos. I ask as I have a database split into fe/be and I found that the forms on the front end with the IIF statements were very slow, but when they were taken out the form was much faster, also during the pause the form says "calculating..." in the status bar.
Would IIF statements on a form cause a slowdown effect in such a case where they look up information in a back end database of roughly 5Mb)?
Thanks again
Ricardo