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

[AccessDatabaseUserInNeedOfHelp2005_01_07]

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.

 

[Wayne Morgan]

Me!cmb_box.ControlSource =

rst_ext_sDebt_Nums.Fields("values_for_combo").Name

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"

 

[AccessDatabaseUserInNeedOfHelp2005_01_07]

I'd like to thank you for your time.

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"