Drop Down Lists

[Saxman]

I have created a few drop down lists on a form using a wizard. I have
entered the values on individual tables for the drop down lists and the
values are displayed correctly in form view.

My problem is that if I enter values using the drop down arrows, the inputs
are repeated on every record. I think I might have my table relationships
amiss?

 

[Douglas J Steele]

Sounds as though your combobox isn't bound to a field in the underlying
recordset of the form.

 

[Saxman]

Sounds as though your combobox isn't bound to a field in the underlying
recordset of the form.

How would I rectify that?

 

[Douglas J. Steele]

Go into the properties of each combobox and type the name of what field in
the recordset it's supposed to relate to in the Control Source box.

If your comboboxes aren't linked to the recordset, then the behaviour you're
seeing (each row having the exact same value) is unavoidable.

 

[fredg]

How would I rectify that?

Set the Combo box's Control Source property to a field in the table.
It's on the control's property sheet's Data Tab.

 

[Saxman]

Set the Combo box's Control Source property to a field in the table.
It's on the control's property sheet's Data Tab.

That worked fine on all combo boxes except one.

I have tried to relate it to a field in the datasheet, but the field does
not appear in the combo list?

The field is certainly active as it records the data in the datasheet view.