multiple value choice

Forum home » Delegate support and help forum » Microsoft Access Training and help » Multiple value choice

Multiple value choice

resolvedResolved · Medium Priority · Version 2007

Dorota has attended:
Access Introduction course
Excel Intermediate course
Excel Advanced course
Access Intermediate course
Excel VBA Intro Intermediate course

Multiple value choice

Hi
I have been trying to change the settings of one of the fields in our contact database to allow us to select multiple values. I have tried to do it by going through the lookup wizard and at the end of the process select "Allow multiple values for this lookup" option, but this option does not appear at all. Would you be able to help me with this problem.
Thank you

dorota

RE: Multiple value choice

Hi Dorota, thanks for your query. This is a difficult one to advise you on because it sounds like it depends on the underlying structure of the database. First of all, double check you have created the lookup field correctly, secondly, in design view on the table, switch to the lookup tab of the field properties and try changing Allow Multiple Values in there. Thirdly, if none of these work, look at the relationships between the tables, particularly if the Lookup is being generated by a one-to-one table relationship anywhere.

Anthony

RE: Multiple value choice

Hi Anthony, thank you for your message. Unfortunately, I have not been able to resolve the problem. I decided to create a new field and re-enter the valus for it, but the wizard does not allow me to select the "Allow Multiple Values" choice. Would you be able to help me with this, please?

Many thanks

Dorota

 

Training courses

 

Training information:

See also:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Access tip:

Zoom feature for queries

If youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field

View all Access hints and tips


Server loaded in 0.08 secs.