The answer to your question is change the bound column of the ComboBox. It is
on the Data tab of the properties sheet for the ComboBox and is 0 based.

I suspect you have a design issue if you are putting the same text in more
than one table.  You may wish to review normalization.

Chris,
  Sounds like you've asked the combo to use the Table as the RowSource...
  Select Query instead, and using the query design grid... set up the fields you want in
the colums you want.

  But... say your selecting a Customer for a transaction of some sort.  You shouldn't
capture the "CustName", you should capture the CustID (unique key for each Customer.
Duplicate names can exist, so your heading for problems eventually.
  The table your using to gather this data should have a CustID field, and your combo
should be bound to that field.

   Setup the combo (ex. name = cboCustID) this way.
   ControlSource = CustID
   Col1 = CustID, Col2 = CustName
   NumberOfCols = 2
   ColumnWidths = 0"; 2"  (hides the CustID from the user)
   ListWidth = 2"

   Okay, here's what happens...
   The combo just "displays" all the CustNames, the user selects a CustName, the combo
"displays" that name... but in reality, CustID is stored in your form table in the CustID
field.  This does double duty... easy for the user to select a name, but really capture
the CustID... which is the key value that will allow you to always relate the data your
capturing back to "one and only one" Customer.