Records don't retain their data

[sunserve]

My database was working fine until I had to make some minor changes in a few of the fields (which I did in the table and the data entry form). Now, all of the combo boxes in all of the records show the same selection. If I change the selection in one of the fields in a record, it changes the selection in that field in all of the records to that selection.

 

[RuralGuy]

It sounds like you are talking about a Continuous Form with an UnBound ComboBox.

 

[sunserve]

I don't know what a continous form is, but all of the combo boxes are bound.

 

[RuralGuy]

Are you looking directly at the table or viewing the table with a form?

 

[sunserve]

I am looking at the form which is used for entering the data that goes into the records.

 

[RuralGuy]

Can you see more than one record at a time or do you have to push a next button? What to do you have the ControlSource of the ComboBox set to?

 

[sunserve]

See only one record at a time. Have to push the > on the bottome to go to next record. Its actually a list box and the control source is the name of the field.

 

[RuralGuy]

I have not experimented with bound ListBoxes before. What do you have the RowSourceType and RowSource set to?