Set Values

[SteveE]

I have a form open which I setvalue for 4 fields via a macro according to which [customer] is selected from a combo box. I use the onexit event to start my macro. The condition is as below:
[Forms]![ExportsSheet]![Customer]="Dell Returns" Or "CIM (WW UK)" Or "ZZZ NON CHARGE" Or "Dell Bulk" Or " Two Way"

My problem is that the macro just sets the values for any customer not just the ones in quote marks. Could anyone suggest where I am going wrong here.

thanks in advance

 

[FoFa]

[Forms]![ExportsSheet]![Customer]="Dell Returns" Or [Forms]![ExportsSheet]![Customer]="CIM (WW UK)" Or [Forms]![ExportsSheet]![Customer]="ZZZ NON CHARGE" Or [Forms]![ExportsSheet]![Customer]="Dell Bulk" Or [Forms]![ExportsSheet]![Customer]=" Two Way"

 

[SteveE]

Thanks very much works a treat now.

Steve