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

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
 
D

Dirk Goldgar

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top