Unbound Field Not Showing Value when on Record Selection

[TinaH]

I created a form with 3 unbound text boxes. The text boxes are populated using a lookup column (assigned when creating the table). The cboZIP_CODE, txtCITY_NAME, txtSTATE_ID, txtCOUNTY_ID (txtCOUNTY_ID is hidden on the form so user does not see it) are stored in the underlying table COMPLAINT upon updated/change of the record.



The unbound field txtCOUNTY_NAME is populated onto the form so that the user can see the COUNTY_NAME but is part of the Lookup Values assigned in the ZIP_CODE lookup within the table.

The issue is that when I use the built in Record Selector at the bottom of the form to view the previous record, the unbound txtCOUNTY_NAME returns empty on previous Record Selection.

How can I keep or at least make the form re-enter the COUNTY_NAME into the txtCOUNTY_NAME unbound text box when going to the previous record?

This issue is also happening on the txtER_COUNTY_NAME and txtREFRD_TXT unbound fields.

I have attached a print screen of the Form and the code that I have placed behind each combo box using the On Change() option.

[June7]

Options:

1. expression in textbox ControlSource
=[cboEE_ZIP].[Column](1)

2. repeat the VBA code in form Current event

[TinaH]

Thank you, that worked. I could not figure out what control to enter the code on.