Combo Box

[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

 

[Dirk Goldgar]

(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

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".

 

[John Vinson]

(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

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.

 

[ZBC]

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#.

 

[John Vinson]

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#.

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.

 

[ZBC]

Thank You!
Bob

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.