error message

[nishkrish]

the value you entered isn't valid for this field , i created table when i go
to design view of table i get this message, i have customer name , city and
state field and Display source is combo box, row source tab/ qry
row source i have query ... SELECT CustomerTbl.CustomerID,
CustomerTbl.CustomerName FROM CustomerTbl;

i went to access help but was not able to understand it properly please help

 

[KARL DEWEY]

How do you have a"Display source is combo box"?
You seem to be mixing table and form information.

 

[nishkrish]

I am sorry it should be display control - combo box
row source type - tbl/ qry
row source is a query

i had copy pasted some data from excel in to the list of name, city and
state so when i go to design view it shows error and when i clicked ok ok it
changes to number 1, 2, 3 .... in all the fields when i take cursor to that
particular field.

 

[KARL DEWEY]

Change Column Widths to something like this -- 0";1"

 

[nishkrish]

Hi Karl,
I have
Bound column 1
column count 2
column heads yes
column widths 0";6"
list rows 8
list width auto
limit to list yes

 

[KARL DEWEY]

Ok, let us back up and go slow.
Did the data paste into the table correctly? Does the query used for the
combo box pull the correct data?

Post an example of the data from the query.

Is column 1 bound to a number or text field?

 

[nishkrish]

CustomerID CustomerName CustCity CustState
1 Adams & Marshall Oakland CA
2 Adams & Marshall 2 f
3 Adams Remco Inc. 3 FL
4 Allen aptist Church Oakland CA
5 Alliance Hospitality Lewis Center OH
6 ALL-Pro Fastener Mansfield TX
7 Adams & Marshall Oakland 4

this is how data shows up if you see certain records have changed to numeric
wehereas all my DataTypes are (TEXT) except Customer ID which is AutoNumber.

 

[nishkrish]

Hi Karl,

Is it possible that since i am trying to input data in table design view
where i have created combobox thats the reason its showing me error, i want
my data to showup in combox from where i can select data. should I be
creating a form and input values there which will automatically update table
that is what i am suppose to do?

 

[KARL DEWEY]

i am trying to input data in table design view
You can not input data in design view.
Yes, The combo box on the form should be bound to the query field derived
from the table.

 

[nishkrish]

Thanks Karl for all your help
--
Nisha P

You can not input data in design view.

Yes, The combo box on the form should be bound to the query field derived
from the table.