Error Message associated with Field

[CQCDave]

I am running into an error message when attempting to save a record. (See Attached picture) The field is populated from a Value List. I select either Accepted or Rejected from the drop down list and continue to populate the rest of the fields. When i attempt to save the record I get the error message. I am a very new Access user, will be going to training next week, just trying to get ahead of the curve. Thanks for any assistance.

[RuralGuy]

Does that ComboBox have anything in the Control Source property?

[CQCDave]

No, nothing in that property field.

[RuralGuy]

In order to place the value selected in the field, that field needs to be the Control Source of the ComboBox. set it to "= AcceptedorRejected" without the quotes and that should do it.

[Dal Jeanis]

At first glance, it sounds like that field on the form is not bound to the field on the table.

(Like RG said.)

[CQCDave]

if i place "AcceptedorRejected" in the Control Box this is the error i get now.

[RuralGuy]

Did you remember the "=" sign?

[RuralGuy]

Because of the first error you were getting, it appears you have a Query and the RecordSource of the form. Does that field appear more than one in the query?

[CQCDave]

This field is only on this form and i do not believe is in any other Query. I entered = AcceptedorRejected into the Control Source field. After i saved it the form it is displayed as =[AcceptedorRejected]. It will display the drop down selections but will not allow me to select one.

[RuralGuy]

Any chance you can post your zipped up db, or at least the SQL for the RecordSource of the form?

[CQCDave]

Here are a couple of more screen shots. Thanks

[RuralGuy]

The behavior you describe suggests you do not have an "AcceptedorRejected" field in the RecordSource of the Form. Maybe try qualifying it further like: = ReceivingInspection.AcceptedorRejected . None of the ComboBoxes displayed have a ControlSource assigned. How complicated is the RecordSource of the Form? It sounds like it contains at least two tables.

[CQCDave]

Thanks for the help

[RuralGuy]

Does that mean you have solved your issue? If so, what was it?

[CQCDave]

In the Source Database the AcceptedorRejected field was listed as a Number field. I looked at the Object Dependencies and found where the error was and was able to chance the field to text.