Error on Required Field that has a Value

[TinaH]

I created a Form based on the table COMPLAINT for the field COMPLAINT_STAT_ID I created a lookup to refer to the V_COMPLAINT_SCR selecting the COMPLAINT_SRC_ID and the COMPLAINt_SRC_DESC and selected that the value be stored in the COMPLAINT_STAT_ID field of the COMPLAINT table. On the form I created an unbound text box (named txtREFRD_BY) and used the COMPLAINT_STAT_ID field as my combo box and named it cboREFRD_BY because the V_COMPLAINT_SRC table holds information on who referred the compainant to this office.
The code behind cboREFRD_BY after update is

Private Sub cboREFRD_BY_AfterUpdate()


Me.txtREFRD_TXT.Value = Me.cboREFRD_BY.Column(1)
End Sub

Which works to populate the field COMPLAINT_STAT_ID and the unbound text field txtREFRD_BY

I have checked the field lengths numerous times and have tested it. On close I make sure that I compact and repair the database however, when I turn it over to the person testing the database they get the following error and when I go back and open the database I also receive the same error.

File AttactedError 1.zip

When I exit out of this error, I then receive an error stating that COMPLAINT_STAT_ID is required. The issue is that COMPLAINT_STAT_ID has a value in it.

What is happening?

[June7]

You say the textbox is unbound and named txtREFRD_BY. So why does the code refer to txtREFRD_TXT? Why use VBA? Expression in textbox ControlSource can be: [cboREFRD_BY].[Column](1).

Post the combobox RowSource SQL statement.

COMPLAINT_SRC_ID and COMPLAINT_STAT_ID fields are autonumber/number type?

Did you set lookup in table? I NEVER do that. http://access.mvps.org/access/lookupfields.htm

[TinaH]

Sorry, the unbound text box is named txtREFRD_TXT

You say the textbox is unbound and named txtREFRD_BY. So why does the code refer to txtREFRD_TXT? Why use VBA? Expression in textbox ControlSource can be: [cboREFRD_BY].[Column](1).

Post the combobox RowSource SQL statement.

COMPLAINT_SRC_ID and COMPLAINT_STAT_ID fields are autonumber/number type?

Did you set lookup in table? I NEVER do that. http://access.mvps.org/access/lookupfields.htm

[June7]

That doesn't respond to my other questions/request. Review the post again.

[TinaH]

Yes, I set lookup in the the table.

[June7]

Do you want to provide response to:

Post the combobox RowSource SQL statement.

COMPLAINT_SRC_ID and COMPLAINT_STAT_ID fields are autonumber/number type?