Thread: Help with syntax
View Single Post
  #4  
Old August 26th, 2009, 07:09 PM posted to microsoft.public.access.forms
Jim
external usenet poster
  
Posts: 39
Default Help with syntax
Thanks!

"Clifford Bass" wrote in message
...
Hi Jim,

Try:

=IIf([cboInvoiceNumber].Column(16)="SH3700" Or
[cboInvoiceNumber].Column(16)="SU8035",[cboInvoiceNumber].Column(9),[cboThirdPartyBilling].Column(1))

Clifford Bass


"Jim" wrote:

I need the correct syntax for using IIf with Or in a form. What I
currently
have isn't working:

=IIf([cboInvoiceNumber].[Column](16)="SH3700" Or
If([cboInvoiceNumber].[Column](16)="SU8035",[cboInvoiceNumber].[Column](9),[cboThirdPartyBilling].[Column](1))

Thanks
Jim