multiple values AND being able to add more

[MyWebdots]

Hi there.
I would really appreciate anyone's assistance with the following please-

I have a client who wants the following on their form:

The abillity to select (tick, checkbox - it doesn't matter) one or more values from a list AND have the option to put another.

The exact request is:
"Recreational Activities Observed - tick from any: paths, parks, swimming, fishing, canoeing, other (describe)."

Can I do both? I am working in MS Access 2007. I am not sure whether it should be set up as separate table or querie or lookup list etc... I am not very experienced and there doesn't seem to be clear answer for this. I would very much appreciate any guidence you can offer please!

Many thanks in advance for your help.

Katie

 

[smig]

you can have a check box for each value, and also a textbox attached to the "Other" one (you can enable this text box ony when "Other" is checked).
when you save/close the form make sure the "Other" text box was filled in case "Other" was checked.

 

[vbaInet]

I would be inclined to go for a Multi-select listbox for this.

To add new records simply create a button that will open a pop-up form for adding a record, then Requery the listbox after it's saved.

 

[smig]

I think it's depend if he want to have the "other" added to the selected options, or have this general "Other" style that you can see on many forms.

 

[MyWebdots]

you can have a check box for each value, and also a textbox attached to the "Other" one (you can enable this text box ony when "Other" is checked).
when you save/close the form make sure the "Other" text box was filled in case "Other" was checked.

Thank you!

 

[MyWebdots]

Thank you to everyone for your help. I ended up just using the checkbox option with "allow value list edits" as YES and it seems to be going the job ok.

 

[vbaInet]

As long as this isn't a multi-user database the checkbox option will do just fine.