List or combo box which stores multiple values.

[Len]

I have limited experience with Access but decided to set one up to record our
product enquiries. Most times people will enquire about one product only but
sometimes it maybe two or three. I have an enquiry/contact table but need to
set up a series of combo or list boxes to select the products (multiple) they
are enquiring about. I have access 2007 and tried the list that stores
multiple values which sort of worked... ie. i could select a couple of
different products per enquiry but it updated all enquiries with the same
information so obviously i dont have something right. Perhaps it is not the
right option?? I set up a product table as well.
Could someone please advise the correct options i should be using to do this
type of thing.

Many thanks

Lindy

 

[Danny J. Lesandrini]

First, the multi-value fields are cool, but not recommended for circumstances
where you will need to query them extensively. It's still a better solution in A07
to use a child, one to many table to store this kind of entity.

But I don't think that's your problem. It sounds like you have a continuous form
and when you set the value on one row, ALL rows take that value. If this is the
case, then you don't have the ControlSource property set to a field in the table.

Check the ControlSource value for this field and make sure it's being saved to
some column in the table. It will appear as a comma delimited list of values.