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
 
Back
Top