Referencing the info instead of bound column record number

[KerryL]

When a combo box is used to make a selection on a form, the item saved in the table is the corresponding record number in the bound column.

For example, if a cbo is used for the STATE field and CA is selected, a 5 is stored in the table. When I pull the record up in a form or for a report, I want CA to show, not 5. But I keep getting the 5.

Why is that? I want CA to appear, either on a different form or on a report, but I'm doing something wrong. How do I get CA to appear instead of the bound column record number?

 

[IGPCS]

well i suggest 2 things or to store the state and not the state id or when creating a form or report base it on a query that uses both tables joined by the state number

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY