Saving multiple values in look-up combo box

[AnnSparks]

I am using Access 2007, and have been trying to add a combo box to my form. I would like for the combo box to save multiple values to two fields (both fields are in one table). I do not get any message about "adding multiple values" when I set up the combo box, and I can't find this in my property sheet. Is there some way for me to save multiple values?
Thanks for your help.

[June7]

Field in table must be set up for multi-value then the combobox bound to that field can be set for multi-select.

I NEVER use multi-value fields.

[AnnSparks]

Thank you for your reply. I don't think I made my question clear, and I do apologize for that.
I am using an unbound combo box, so neither column is tied to any table field. I created a query, from one table (tbl_Wells), with the two columns for the combo box (customer name and well information). The unbound combo box is in the header portion of a form with two subforms. When the user selects a customer & well, the data selected in the combo box ideally would be tied to two fields in the tbl_Invoice_Header - this would help control data input.

If this is not possible, can I restrict the well information displayed to only show the wells tied to the selected customer? I am a novice with VBA.

Thanks - have a good day, Ann

[orange]

Ann,

There is info at Martin Green's site on dynamic reporting. I think it may be useful to you especially the dialog stuff.
It's worth a read. I hope it is applicable.

I don't use, nor recommend, multivalued fields either.

[June7]

You might want dependent (cascading) comboboxes. Review http://www.datapigtechnologies.com/f...combobox2.html

[AnnSparks]

I have checked out both sites and have found some great information. I have decided to use the regular combo boxes for my form. I don't want the users to run into problems. I appreciate your help - thanks.