Item selected in combo box afftects all records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I stop an item in one combo box from affecting all records.
ie. City is my heading and I select Hilo from the list. When I go to the
previous record it is changed to Hilo. Anytime I make a change on
one record it affects all records. Please Help!

Thanks
 
You're using unbound combo box in a continuous forms view. Won't work. Combo
box will hold a separate value for each record only if the combo box is
bound to a field in the form's record source, or if the combo box's control
source is an expression.

You'll need to add a field to the query to hold the combo box's value; it
may mean adding a field to a source table in that query to get it there.
 
Back
Top