Referring to multiple combo box columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Do you wish to concantenate Column(4) & Column(1) or are you trying to do a
Boolean AND?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stupid problem with combo box 2
Combo box help please 5
Trouble Filtering a Sub Form With Combo Box Options 2
Combo Boxes & Filtering Value 4
auto populate text box based on combo box value 1
my combo boxes 2
sum combo box based on other combo box 2
List box selection into combo box 2

Back
Top