Unbound text box display disappears

[basshead22]

Hi All,

I have an unbound text box on a continuous form that displays my description from my combo box.... and it works fine but when I click on the next record or put the cursor on another record field it disappears how do I make it appear regardless where my cursor is? Hope this makes sense.

=[CmboProject].[Column](3)

 

[CJ_London]

do you have any code which modifies the rowsource for the CmboProject control? e.g. to modify the options available depending on the value of another control on the form?

 

[basshead22]

Yes I do ! I have another combo that narrows the selection in my ComboProject.

 

[CJ_London]

That will be why then. If you think about it.

You set the rowsource A,B,C
You select A
Then you change the rowsource to D,E, F
>> A is not in that list so there is nothing to display

What you can do is in the comboctrl enter event is assign the filtered list to the rowsource

myCombo.Rowsource="SELECT Fld1, Fld2 FROM myTable WHERE Fld3=" & me.partno

And in the comboctrl exit event reset the rowsource without the filter

myCombo.Rowsource="SELECT Fld1, Fld2 FROM myTable"