Combo box problem 'Limit To List' not working

[Guest]

I have a form with a combo box that pulls from a preset list of choices in a table. I don't want the user to be able to modify or add to this list, so I have set Limit To List to "Yes" The problem is if I choose something from combo box on my form, it will modify an entry in my source table duplicating the last entry selected, resulting in a list that looks like this:

One
One
Three

instead of the original table data:

One
Two
Three

 

[Gerald Stanley]

It sounds to me that you may have an incorrect setting for
the combo's Control Source. If the form's RecordSource is
the same table that is providing the list for the combo-box
and the combo-box's ControlSource is the same column that
is the source column for the list, that would give rise to
the sort of behaviour that you are witnessing.

Hope That Helps
Gerald Stanley MCSD

-----Original Message-----
I have a form with a combo box that pulls from a preset

list of choices in a table. I don't want the user to be
able to modify or add to this list, so I have set Limit To
List to "Yes" The problem is if I choose something from
combo box on my form, it will modify an entry in my source
table duplicating the last entry selected, resulting in a
list that looks like this:

 

[Guest]

Thanks for the reply, that sounds like it might be why I am having problems, but I don't know how to solve it

My form links to a main table that has smaller lookup tables linked to it (used table analyzer to create lookup tables of commonly repeating data), but using this method in conjunction with combo boxes results in the above problem

I simply want 'Drop-down list box' type functionality on my form (Access only offers combo and list box on forms), that pulls the list box choices from a table, rather than a Value list

Any suggestions on how to achieve this goal?

 

[Gerald Stanley]

Let's assume that your form links to tableA, the values
that you want to see in your comboBox are in tableB and the
comboBox links to columnC in tableA

Then, the RecordSource for the Form should be set to
tableA, the RowSource for the Combo should be tableB and
the ControlSource should be columnC.

Hope That Helps
Gerald Stanley MCSD

-----Original Message-----
Thanks for the reply, that sounds like it might be why I

am having problems, but I don't know how to solve it.

My form links to a main table that has smaller lookup

tables linked to it (used table analyzer to create lookup
tables of commonly repeating data), but using this method
in conjunction with combo boxes results in the above problem

I simply want 'Drop-down list box' type functionality on

my form (Access only offers combo and list box on forms),
that pulls the list box choices from a table, rather than a
Value list.