combo box field assignment

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

Guest

I have a combo box with two fileds, (rows) in it that I want the data to be
put in the table. I can only get the bound field, (row) to register in the
table the other field, (row) dose not. Hoe do I get the datat from both
fields, (rows) to be input into the table.

thanks
 
Hi, Trashman.

I think you mean "columns" rather than rows. Each row represents a record
in the Row Source.

You can only store the Bound field, which should be a foreign key. This is
as it should be. You can get the value of any other field in the RowSource
through a query. For example, in an Orders table, you would store only the
CustomerNumber. Storing the CompanyName is not necessary (nor desirable!)

Now, if you wish to also *display* other fields from the RowSource on your
form, simply include them as columns in the combo box, and use the Column
property of the combo box. It is 0-based--the first column is 0. So to
display the third column in a textbox, set its Control Source to:

Me!YourComboBox.Column(2)

Hope that helps.
Sprinks
 
Back
Top