Hello all...I'm a bit new to working with Macros in Access so forgive
me if the terminology I use is not accurate.
To preface this, basically I am using a form on a replicated database
so the end-user can filter on a specific report they want to see. This
database was designed by my predecessor (of which he left no
documentation) and I need to add some additional functions to this
end-user filter report.
Within one Macro, he has over 30 conditional actions. I have since
added an additional attribute to the database (public
comment/non-public comment). I want to make this an option when
filtering reports. I've added about 5 new conditional actions that
incorporate this and they worked (including the original 30 conditional
actions within the same macro). After I add the sixth conditional
action, the new action works, but then most actions underneath it do
not work (there are no error messages...it just doesn't recognize the
filter constraints).
My question --- could it be the order in which I add these actions? Or
could it be a limitation of Access?
Thank you --- any help would be greatly appreciated. This has been
driving me nuts all weekend. If you think you might be able to help
and need additional info or examples, please let me know and I'll get
them ready. Thank you!!!!