Combo Box

  • Thread starter Thread starter ZBC
  • Start date Start date
Z

ZBC

(I tried an earlier post ... go not response.)

How do I make a combo box not editable by the user if it is based off of
a table?
I tried locking it ... that did not work

Bob
 
ZBC said:
(I tried an earlier post ... go not response.)

How do I make a combo box not editable by the user if it is based off
of a table?
I tried locking it ... that did not work

Bob
Click to expand...

What do you mean by "not editable"? If you set the control's Locked
property, the user will *not* be able to change its value, so that can't
be what you mean by "not editable".
 
(I tried an earlier post ... go not response.)

How do I make a combo box not editable by the user if it is based off of
a table?
I tried locking it ... that did not work

Bob
Click to expand...

I *think* you may mean that you want to set the combo's Limit to List
property to True. This will restrict the user to selecting one of the
existing entries, and prohibit typing something that is not predefined
in the list.
 
You might want to look at my other post "Confused on Record Source vs
Control Source ?"
I want to keep the user from changing values in tblUsers ... I am using
tblUsers as a list (limited as such) of the possible choices of User#.
 
I want to keep the user from changing values in tblUsers ... I am using
tblUsers as a list (limited as such) of the possible choices of User#.
Click to expand...

If you're using the combo box to navigate to a record, the combo box
MUST BE UNBOUND: its Control source should be blank.

The RowSource is a table, query, or list of values *from which the
combo gets its data*.

The ControlSource is a field in the form's recordsource *into which
the combo puts the selected value*.

If you don't want a value put into the table when you select from the
combo, just leave the Control SOurce blank.
 
Thank You!
Bob

John said:
If you're using the combo box to navigate to a record, the combo box
MUST BE UNBOUND: its Control source should be blank.

The RowSource is a table, query, or list of values *from which the
combo gets its data*.

The ControlSource is a field in the form's recordsource *into which
the combo puts the selected value*.

If you don't want a value put into the table when you select from the
combo, just leave the Control SOurce blank.
Click to expand...
 
Back
Top