Combo box

[angie]

I have customer form that has a combo box where we pick the owners billing information from. It has a not in list event that opens a form to add owners info. On the owners form there is a text box for. Name, address, state, city, zip. I would like to have the combo box once selected with the right owner to show the following. Owner name. (Next line) address (next line) city, state, zip.
The combo row source is a select query. The on not in list and the on dbl click is a event procedure .see attachment.
















Thanks for your help


Angie

[pbaldy]

Little hard to read upside down.

is is this what you're after?

http://www.baldyweb.com/Autofill.htm

[June7]

The combobox cannot show data from same record on multiple lines.

Not sure how the code is relevant to the question.

Next time, try just taking a Screen Print instead of using a camera.

[angie]

Sorry for the upside down. First time I have used a attachment.
Could I select a name in the combo box and have another box to show the address on the customer form. ( the address would come from the company owner form).

[June7]

Paul's link describes one method to accomplish that.

[angie]

I have to have it like a mailing address. I us this data in other forms such as invoices as a nz default value. Before I only had one field that contained the name and address. But I wanted to have a field for each if possible

[June7]

An expression in a textbox can concatenate data.

Or have separate textboxes arranged one below the other.

[angie]

I have tried both ways here is the code I used for after update event for the combo box

private sub company_owners_name_afterupdate()
me.billing_info = me.company_owners_name.column(2)
end sub


i can see the 2 column when selecting the drop down but it does not update the text box

I think I have something wrong

[trevor40]

combo box's are 0 based try me.company_owners_name.column(1) if you have 2 fields

[June7]

As trevor said, combobox/listbox column index is 0 based, so column 1 is index 0.

Are you trying to save the info into record? That is duplicating data.

To just display the info from combobox, an expression in textbox could be:

=[company_owners_name].Column(1) & Chr(13) & Chr(10) & [company_owners_name].Column(2)

Code is only required if need to save to a record.

[angie]

Thanks that worked great, can I use a string expression in the query to show more than one field

[June7]

Expression with concatenation can be done in query.

[angie]

Thank you Trevor and June. It works great.