Combo Box

[Warrren]

I have a table called Household and I need to add multiple entries to a field
called Activity. The activity column holds information on the level of
membership i.e regular; occasional, Warden,ParCouncillor,mail only, etc.
I have created a combo box with most of the above entries but I can only
enter one value into the table cell when I need to enter sometimes 3 values.

Thanks for any help.

 

[Daniel]

In that case you need to make a separate table to house the information and
link it to the primary table based on your primary key using table
relationships. You will also then need to make a minor mod to your form.

Take a look at

http://www.functionx.com/access/
http://www.bcschools.net/staff/AccessHelp.htm

both sites covert the basics about access including relationships...

Daniel P

 

[John W. Vinson]

I have a table called Household and I need to add multiple entries to a field
called Activity. The activity column holds information on the level of
membership i.e regular; occasional, Warden,ParCouncillor,mail only, etc.
I have created a combo box with most of the above entries but I can only
enter one value into the table cell when I need to enter sometimes 3 values.

Thanks for any help.

That's like saying you have a one-dozen egg carton and you need to put
21 eggs into it.

A Field can have ONLY ONE VALUE. You need to step back from the Form a
bit, and reconsider your table design.

If one Household can participate in many Activities, and each Activity
can involve many Households, you need *a new table* - Participation,
let's call it; this should have (at least) two fields, one a link to
the primary key of the Household table, and the other a link to the
primary key of the Activities table.

For data entry you would use a Form based on the Household table, with
a Subform based on the Participation table. On this subform you would
have a combo box based on Activities (which should be a separate
table, not a value list, for ease of maintenance); for each activity
in which a household is involved you would add a new record to the
Participation table.

John W. Vinson [MVP]