Why would a bound ComboBox control not allow me to edit its conten

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

Guest

Reiterating the question:
Why would a (ADO Recordset) bound ComboBox control not allow me to edit
contents? I don't know if it helps to say that the recordset comes from a
called to a SYBASE stored procedure.

The control does not allow me to pick or edit its contents.


Here's the pseudo code:

rst_recordsetname.CursorLocation = adUseClient
rst_recordsetname.CursorType = adOpenStatic
rst_recordsetname.LockType = adLockOptimistic
strSQL = "ext_sDebt_Nums"
rst_ext_sDebt_Nums.Open strSQL, Connection_Obj

Set Me.Form.Recordset = rst_recordsetname
Me.DataEntry = False
Me.AllowAdditions = False
Me.AllowEdits = True
Me.AllowDeletions = False
Me!cmb_box.ControlSource = rst_ext_sDebt_Nums.Fields("values_for_combo").Name
Me.Form!fieldname.Locked = False

I'm using Access 2002.
 
Me!cmb_box.ControlSource =
rst_ext_sDebt_Nums.Fields("values_for_combo").Name
Click to expand...

Just guessing by the names you have here. If this is really "values for the
combo box", then should it be the Row Source, not the Control Source? The
Row Source will give you the selectable values, the Control Source is the
field the combo box is bound to (i.e. the field you want to store the
selected value in).

--
Wayne Morgan
MS Access MVP


"AccessDatabaseUserInNeedOfHelp2005_01_07"
 
I'd like to thank you for your time.

Wayne Morgan said:
Just guessing by the names you have here. If this is really "values for the
combo box", then should it be the Row Source, not the Control Source? The
Row Source will give you the selectable values, the Control Source is the
field the combo box is bound to (i.e. the field you want to store the
selected value in).

--
Wayne Morgan
MS Access MVP


"AccessDatabaseUserInNeedOfHelp2005_01_07"
Click to expand...
 
Back
Top