The "x" lookup column was changed to store multiple values. You cannot reverse this setting. RRS feed

  • Question

  • Hi Good Morning everyone hope you're having a great day,

    I've been having this issue on access for a while with a database that I'm constructing. I have a combo box that people fill out with a list of users initials, in which the user chooses their own initials... however for some reason my combobox has appeared as a multiple choice with tick boxes on the side, obviously one user cannot be two or more people thus I want it so you can only select one user (it's 100% not set as a tickbox)… furthermore I think I almost got to the route of the issue as I went into the table where the initials are meant to be entered into, clicked the relative field- lookup-allow multiple values-no, but when I went to save it I got the message shown in the title above. 

    Apologies if that's a bit hard to follow, I will be happy to answer any questions if need be. 

    If anyone could help me I would thank you a million and seven times. 



    Tuesday, July 2, 2019 9:35 AM

All replies