rowsource problem

[Stuart]

I have a subform, can be either a datasheet or continuous
forms. I have a combo box whose rowsource depends on a
previously entered value on that particular line.
Changing the rowsource (via OnEnter for the combo box)
seems to change it on all lines, not just the current
line. Is there a way to solve this?

Thanks, Stuart

 

[Chris]

-----Original Message-----
I have a subform, can be either a datasheet or continuous
forms. I have a combo box whose rowsource depends on a
previously entered value on that particular line.
Changing the rowsource (via OnEnter for the combo box)
seems to change it on all lines, not just the current
line. Is there a way to solve this?

Thanks, Stuart
.

 

[Stuart]

Have tried that.

-----Original Message-----

.

 

[Andrew Smith]

You only have one combo box, with one row source - you just see several
copies of it. So changing the row source means that it will "seem" to change
the row source in all lines on the form, because there is only one combo box
and one row source!

Since the combo box in all but the current row will not be expanded, this
may not be a particular problem. I guess the issue is that the value of the
bound field on the combo box will not be visible on records that are not
selected. You might be able to work round this by making the combo box
narrow so that just the arrow is visible, and then adding a text box to
display the same value as the combo box should display.

 

[Stuart]

Very diabolical and practical solution. I have put a
text box on top of the combo box so only the arrow shows
through. Works fine!

Thanks, Stuart