ComboBox shows Autonumber data, not selected data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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

Similar Threads

Access 2010 query for 3 tables 0
Add autonumber to a large table? 0
Help with a Macro! 4
Autonumber issue 2
Autonumber Macro 3
primary key - concatenated or autonumber? 6
Data Validation 1
Data type: Autonumber 4

Back
Top