combo box problem with data

[Johnny0123]

hi,

I have one combo box that depends on another. What my problem is that the data selected in the combo boxes will stick and when another record is selected that data is repeated. So when i change the data in one record, all the records change to the new data. Looking for a way to stop that.


Thanks,

John

 

[PHV]

Don't know if this is your issue but be aware that an unbound control in the Detail section of a continuous form has the same value for all the records.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Johnny0123]

PHV,

ur on the money... that is exactly the setup, but i am not sure how to fix the problem


Thanks

John

 

[PHV]

Either bind the combo to a field of the underlaying Table/Query or put it in the Header or Footer section.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Johnny0123]

PHV,

when i bind the combo it wont let me select a choice and says at the bottom of the form "control is bound, cannot be edited"

And when i put the text boxes in the footer section they do not display on my form


What am i doing wrong?

 

[Johnny0123]

PHV,

i have a combo box with a job # then the second combo box is a sequence # related to job #. Finally after the job # and the sequence # are picked two other text boxes are filled with the information linked to their fields.

This is in a datasheet view. The problem is when the second combo box is clicked in the second record row (Which is the sequence #). The sequence # combo box is unbound, but it will change all records(seq#) to the same value when one seq# is changed.

Thanks in advance for the help!!

-John