Help with Macro Conditions

[sai_rlaf]

Hi. I have created a macro that is on a form embedded on a command button. After they fill out the form and click the button, what I would like to have happen is that form will be sent to the applicable department. The right department is determined by which [Department Help Topic] they choose. Now my problem is that my macro is running true for both sets of criteria when i only want one. An example of my conditions are below.

[Forms]![Ops Help]![Department Help Topic]="Account Maintenance" Or "Brokerage New Accounts"
[Forms]![Ops Help]![Department Help Topic]="General Fees" Or "Brokerage Fees"

These are two different macro lines and if the record that is filled out is with one of the first topics it will go to that department, if the two others it will go to a dfferent. All i have get it to do, is send an email to each department since it's reading both as true. Any help you can provide to make my conditions only look at the record I am submitting for is appreciated!

[sai_rlaf]

I will also say that with my macro it also places a Now() timestamp in a field. Not sure if that can be leveraged at all but thought i would throw that out there

[June7]

I don't use macros, only VBA. Having hard time visualizing what you are describing. Do you want to provide project for analysis? I don't understand why it will not look at only the current record.

[sai_rlaf]

This one is good. For some reason if i just reference the field and take out the or statements it works as designed. Thanks for the help though!