Error message "The value you entered isn't valid for this field"

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

I have created a combo box in a form with a subform. I
continute to get the error message "The value you entered
isn't valid for this field" and I can only figure it has
something to do with the combo box on my form that I'm
using for company name. I'm using the Order Entry
database shell to work with and have made changes. I
can't get rid of this error message when I try to go from
one record to the next. I've checked all the properties
for the phone number and fax number fields, which is
where the error message seems to be triggering from, and
can't seem to get rid of the error message.

Can anyone out there help me as soon as possible?

Thanks,
Pat
 
Pat said:
I have created a combo box in a form with a subform. I
continute to get the error message "The value you entered
isn't valid for this field" and I can only figure it has
something to do with the combo box on my form that I'm
using for company name. I'm using the Order Entry
database shell to work with and have made changes. I
can't get rid of this error message when I try to go from
one record to the next. I've checked all the properties
for the phone number and fax number fields, which is
where the error message seems to be triggering from, and
can't seem to get rid of the error message.

Can anyone out there help me as soon as possible?

Thanks,
Pat
Click to expand...

I don't see why you refer to the phone & fax number fields, when you say
your error is related to the combo used for company name. The following
suggestion is based on the idea that the problem is with the binding of
the combo box, but I may be missing something. If so, please write back
with more information.

Make sure the bound column of the combo box is appropriate for storing
in the field to which the combo box is bound. For example, if the combo
box's bound column is the company name, but the controlsource is storing
the selected value in CompanyID, you'll get a message like that.

If that's the problem, set the combo box's rowsource to a query that
includes both CompanyID and CompanyName, set the Column Count property
to 2, set the Column Widths property to hide the CompanyID column, and
set the Bound Column to the CompanyID column. That way, the user will
see and select the company name, but the CompanyID will be stored in the
table.
 
Back
Top