Fix Unbound Text Box Values Disappearing in Microsoft Access Forms

Open your form in Design View, select the target text box, open the Property Sheet (Data tab), and set the 'Control Source' to the appropriate field in your underlying table.

Select the combo box on your form, navigate to the Event tab in the Property Sheet, and click the ellipsis (...) next to the 'After Update' property to open the VBA editor.

Add VBA code to assign the combo box column values to your bound text boxes. For example: Me.YourTextBox = Me.YourComboBox.Column(1). Save and close the VBA editor.

Right-click your Microsoft Access form and select Design View. Click on the unbound text box where you want the related data to appear.

Open the Property Sheet and navigate to the Data tab. In the 'Control Source' field, enter an expression referencing the combo box column, such as =[PropertyAddress].Column(2).

Switch back to Form View. The text box will now automatically populate and retain its display value based on the current combo box selection, even after reopening the form.

Open the VBA editor, insert a new standard Module, and write a function that accepts a separator character and a parameter array of string values.

Inside the function, loop through the array to check for non-blank parameters. Append only the valid strings to a combined result variable, adding the separator between them.

In the combo box's AfterUpdate event, call this new function passing your combo box columns (e.g., Column(1), Column(2)) and assign the cleaned result to your target text box.