Textbox shows #Name? instead of actual value

[jryel1]

I have a form with a textbox that is showing a column of a combo box. When i first create the textbox it works great. The moment I close and reopen the database, it shows #Name?. The code for the textbox is:

=[cboOwner].[column](1)



I am sure that the textbox control source is typed correctly. The combo box name is cboOwner. Why is it not retaining the value once I close and reopen the database?

[RuralGuy]

Forms do *not* store data, tables do. The ComboBox has no initial value so the TextBox is basically lost at that point.

[jryel1]

Found the answer.

[RuralGuy]

Care to share your answer with others that read this forum? And why not go ahead and use the Thread Tools and mark this thread as Solved?

[jryel1]

actually its partially solved. The textbox name and the column in the combo box were named the same thing. I changed the name but it still happens when I exit and come back into the database.

[RuralGuy]

Is your ComboBox bound (does it have a ControlSource)?

[jryel1]

Yes it is bound and have a control source.

[RuralGuy]

Does the cbo display a value when you first open the form?

[jryel1]

Yes it does. It displays the bound column.

[RuralGuy]

Hmm...try putting a Me.TextBoxName.Recalculate in the CurrentEvent of the form. ...using your TextBoxName of course.

[jryel1]

Tried puting Me.txtFirst.Recaluclate in the On Current and it gives an error that it doesnt recognize Me. But for some reason, now the text box is working fine. I have closed and opened the database several times and it is no longer showing #Name? in the textbox. That is wierd. I will keep you posted.

[RuralGuy]

I would *import* the current db into a fresh new db now. It sounds like you have been working with some corruption. http://www.btabdevelopment.com/ts/impnew

[RuralGuy]

You might also take the time and use the Thread Tools to mark this thread as Solved.