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.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Help with Error
- Thread starter CQCDave
- Start date
What is the Control Source of the Accepted or Rejected drop down list?
Duane
Hook'D on Access
MS Access MVP
Duane
Hook'D on Access
MS Access MVP
That error looks like a "Validation Text", which was defined by the person who developed the form. So you can make validation rules for controls, forms, and table values. Go to design view and look in the properties of the combobox. Look at the validation rule, and verify this by looking at the validation text. If you see a validation rule post back. My guess is the rule is incorrect, so it is providing the message. Also post the "rowsource" and "bound column properties" for the combobox.
- Thread starter
- #4
- Thread starter
- #5
- Thread starter
- #7
- Thread starter
- #8
Apparently the bound column of the combo box doesn't match the data type or size of the bound field from the form's record source. If you can't repair this, please reply back with
[ul]
[li]the data type and size of the AcceptedorRejected field[/li]
[li]the Row Source of the combo box[/li]
[li]the bound column number of the combo box[/li]
[li]the data types and sizes of the fields in the Row Source of the combo box[/li]
[/ul]
Duane
Hook'D on Access
MS Access MVP
[ul]
[li]the data type and size of the AcceptedorRejected field[/li]
[li]the Row Source of the combo box[/li]
[li]the bound column number of the combo box[/li]
[li]the data types and sizes of the fields in the Row Source of the combo box[/li]
[/ul]
Duane
Hook'D on Access
MS Access MVP
Dave,
That error message is then not coming from the control, but from the validation rule and text in the table. Go to the table in design view. Click on the field and post a picture showing the field properties. Then we will know the validation rule and the field datatype. Likely the field is numeric not text.
Duane,
From the OP's error3.jpg:
the Row Source of the combo box: Value List - "Accepted";"Rejected"
the bound column number of the combo box: 1
That error message is then not coming from the control, but from the validation rule and text in the table. Go to the table in design view. Click on the field and post a picture showing the field properties. Then we will know the validation rule and the field datatype. Likely the field is numeric not text.
Duane,
From the OP's error3.jpg:
the Row Source of the combo box: Value List - "Accepted";"Rejected"
the bound column number of the combo box: 1
- Thread starter
- #12
To clarify need to look at the table the has the field "AcceptedorRejected". Need to open that table in design view. Then click on the field "AcceptedorRejected". Look at the properties for the field "AcceptedorRejected".
The combo appears fine. The problem is that it is trying to stick a value of "Accepted" or "Rejected" into the field "AcceptedorRejected" and that field may be numeric or a string less than 8 characters.
The combo appears fine. The problem is that it is trying to stick a value of "Accepted" or "Rejected" into the field "AcceptedorRejected" and that field may be numeric or a string less than 8 characters.
- Thread starter
- #15
CQCDave,
Since a couple of us spent some time attempting to help, would you mind sharing the solution?
Duane
Hook'D on Access
MS Access MVP
Since a couple of us spent some time attempting to help, would you mind sharing the solution?
Duane
Hook'D on Access
MS Access MVP
SkipVought
Programmer
Hey CQC,
Did any of these guys give you advice that you liked? See those Little Purple Stars below easy post?
"...thanks" for WHAT??? You never said.
Did any of these guys give you advice that you liked? See those Little Purple Stars below easy post?
"...thanks" for WHAT??? You never said.
- Thread starter
- #18
Sorry..new to the forum..and to Access.
Here is what i was able to figure out with the help from all...
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.
Here is what i was able to figure out with the help from all...
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.
- Status
Similar threads
- Locked
- Question