value from combo box

  • Thread starter Thread starter LJG
  • Start date Start date
L

LJG

Anyone tell my why this is not working and keep getting a #Name? error

=Forms!frmLeaseRates!cboRates!column(1)

Thanks
Les
 
try

=Forms!frmLeaseRates!cboRates.Column(1)

also, frmLeaseRates must be open. other than that, just check the names of
the form and the control to make sure they're spelled *exactly* right.

hth
 
LJG said:
Anyone tell my why this is not working and keep getting a #Name? error

=Forms!frmLeaseRates!cboRates!column(1)
Click to expand...

As a less likely other possibility to Tina's excellent suggestions, remember
that the Column() property is zero based; if your combo's rowsource contains
only one column then Column(1) will not exist - use Column(0) instead or make
the only column the bound column and simply use

=Forms!frmLeaseRates!cboRates

John W. Vinson/MVP
 
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

cascading combo box error message 22
cascading combo boxes requery problem 6
Combo Box Value in Calculation 1
Combo box values 2
Value in Combo 1 based on combo2 1
my combo boxes 2
Trouble Filtering a Sub Form With Combo Box Options 2
display a value based on a combo box 13

Back
Top