ComboBox shows Autonumber data, not selected data

C

Cheech73

The DB does contact management / leads fulfillment for a magazine. I have
numerous demographic fields on a form (combo boxes) that pull from an equal
number of tables that store reader service information.
Here's a brief i.e. from one of those relationships-
Table: ProjectStart
Fields: ProjStartID as Autonumber, and ProjectStart as text
The data in ProjectStart allows form users to select when a reader's project
will start... 0-6 months, 7-12 months, 1-2 years, 2-3 years.

Here's the problem. On my form, when you select any of the above "answers",
they appear correctly on the form. In my table, and subsequently, on my
reports, I only get the Autonumber data - "1" for 0-6 months, "2" for 7-12...
etc...

Seems like an easy thing to fix but I don't know where to look.
Thanks all.
-Frank
 
C

Cheech73

AHA! Answered my own question - all I had to do was change the bound column
from "1" to "2"
 

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