RowSource question

[ermcc]

I am using (2) combo boxes. The second is a requery from the first. As you can see in the code below, I am getting "PartNumber" in the second combobox. I have several fields setup in the second combobox. How do I get multiple fields to come out in the second combobox? Is there a way to add multiple fields to RowSource or do I need to do this differently?

Thank you...

Private Sub CboCustomer_AfterUpdate()
Me.ComboComplaint.RowSource = ""


DoCmd.OpenQuery "clear_combobox_table"
DoCmd.OpenQuery "combobox_sort"
Me.ComboComplaint.RowSource = "Select PartNumber From Combobox"
CboCustomer.Requery
End Sub

[Robeen]

In the Properties Sheet -> Format Tab -> use the Column Count property.
I have a combo box showing two fields and the Column Count is set to 2.

Hope this helps.

[ermcc]

I have the column count set to 17. I want use all 17 fields, but the rowsource command is only giving me one field. That is the problem.

[Robeen]

I just did a real quick test Combo Box on a Test Form. I used the Combo Box Wizard to set it up with 4 fields.
It all worked really well.

Does your Row Source for the Combo Box in which you want to see multiple fields have a 'Select' statement that selects all the fields you need to see?
For instance, this:

Me.ComboComplaint.RowSource = "Select PartNumber From Combobox"

would only return the PartNumber for display in the ComboCompliant box.

If you wanted it to show more fields, you would do something like this:

Me.ComboComplaint.RowSource = "Select PartNumber, Field2, Field3, Field4  From Combobox"

Hope this helps!