access 2003 dropdown not capturing info

[Papa Jonah]

I have created a bunch of forms over the years that have dropdowns with names
and such. I always use a lookup table with a name and an id number. So I
would have:
number name
1 jim bob
2 nancy jo
etc
The cbo has two columns with the width of the first one zero. The first
column is bound to the table where all of the data is stored.
I am currently doing the same thing in a new form, but the data is not
getting captured. After I make a selection from the dropdown, nothing
appears in the combobox window. I have done this a million times and can not
figure out what I am missing in this case.
Any ideas what I need to look at?

Thanks,
Papa J

 

[Klatuu]

Post the code you are using to do this.

 

[Dale Fye]

ColumnCount = 2
BoundColumn = 1
Column width : 0"; 2" - or something like this

What is the data type of the field you have bound the column to?

 

[Papa Jonah]

The query I am using for the row source of the cbo is:
SELECT tblEmployee.EmployeeID, tblEmployee.EmployeeName
FROM tblEmployee
ORDER BY tblEmployee.EmployeeName;

Bound column: 1
Column Count: 2
Column widths 0";1.5"

The field in the table I am trying to save the data to is a number - long
integer field.

Papa J

 

[Papa Jonah]

I just figured it out. When I changed the field in the table from text to
number in order to do this, I did not update the controlsource to reflect the
new name of the field from txtToWhom to numtowhom.

Thanks for the help.