Referring to multiple combo box columns

G

GaryS

Having trouble referring to more than one column. The first statement below
works, the 2nd gives "error" as a result. Any help would be appreciated.

If Me.InsFactor.Column(2) = 1 Then Me.InsRate = Me.cboTerm.Column(4)

If Me.InsFactor.Column(2) = 2 Then Me.InsRate = Me.cboTerm.Column(4) And
Me.cboTerm.Column(1)
 
R

ruralguy via AccessMonster.com

Do you wish to concantenate Column(4) & Column(1) or are you trying to do a
Boolean AND?
 
Top