Why is my form reporting the ID # not the info?

[mattmurdock]

Was wondering if someone could take a look at the attached db and explain how to fix the fact that "New Item Form" is creating records to table NDP with the category ID not the selection.

Thanks in advance!

[John_G]

Hi -

I can't open the database (I have A2003), but here are some questions to give you an idea of where to look:

Is the Category selected from a Combo Box?
If Yes then:
How many total columns are in the combo box, including ones that are hidden?
Which column is bound to the underlying table? (That's the important one!)

HTH

John

[mattmurdock]

Hi, yes its selected from a combo box.

There are 2 total columns (Column Count =2)

I don't know exactly which column is bound to the underlying table but I think its Can_Size

[mattmurdock]

I just figured it out, had to change bound column to 2. Thank you very much! lifesaver!