Columns from a Query in a Form

[Stephanie T.]

I hope this is an easy one...

I have a table that holds our Order Data, in that table I have a Query to pull specific Customer information (from that table) so that when my data entry person is in the Order Data form filling out newly processed orders, she can simply pull the customer information from a Combo Box. That all works great.

However, each customer has several shipping addresses. In the Customer pull down Combo Box on the form you can see the three columns of each Customer Name, and each of their Shipping Addresses, and Notes. That works great.

The problem: once she chooses a customer, the form only shows the customer's name. How do I get the form/combo box (possibly in the table itself) to show all three columns of information.

Thank you,
Stephanie

 

[jimbrooking]

Stephanie,

How about using a subform to display the 3 values, keyed to the combo box? The subform's recordsource could be the same as the combo box.

Jim

 

[Stephanie T.]

Jim,

Thanks for the suggestion. I was hoping to avoid using a subform. This information is already in a subform elsewhere, and while I could simply create another one, not a problem, it would be so much cleaner and easier, if I could just have all three columns that show in the pull down of the combo box, show on the form (and subsequent table).

Thanks anyway,
Stephanie