Textbox displays info but can not edit.

[Yiannis]

Please some help

I have few (15) textboxes in a form displaying information but they can not update.
e.g. It display's the Address_No but if I want to change it i.e. from “9” to “11” it will not update and keep record.



My Textboxes do not have a control source. They can be displayed either from option 1 or 2:

1. Me.Address_No = Me.ComboCities.Column(2)
2. Address_No = DLookup("Address_No", "query2")

To populate date for the above mentioned TextBoxes I previously used 2 ComboBoxes, thus the reason I used the above two options.

Thank to you all in advance.

[RuralGuy]

You cannot edit a control that contains a formula.

[Yiannis]

You cannot edit a control that contains a formula.

I have two cascading combo boxes that do not have a control source and are followed by text boxes (unbound and without control source) displaying info depending on the choices I made with the two combo boxes.
ComboStates followed by ComboCities and then text boxes display info of Cities as addresse, population ....

If I had one combo box the I would have a control source, and my text boxes could have control source, that was my first design but now I need 2 cascading combo boxes.

I am selecting records through the combo boxes,
Form work as:
First combo - I select States
Second combo - I select the Cities from a particular State
On Click, text boxes follow displaying general info of the city.
Text box Address_No displays Address_No record from table.

I would like to override the Address_No record displayed and enter new info where it will be saved if I need to.

[RuralGuy]

I thought you said you were filling in unbound TextBoxes. What is this Address_No overide you are talking about?