How to change ComboBox drop down menu from displaying checkboxes for multiple values

[Mohamster]

Hi there,

I hope the title isn't too confusing. Hopefully I can encapsulate better here. I have an issue with a couple of my combo boxes. When in form mode the drop down menu displays a list of options (taken from my source table), this is fine, but the problem is that it allows the user to select more than one of the options in the form of checkboxes. This is not what I intended.

I've attached to pictures to demonstrate the problem. The first is ComboBoxQuery (the one with the problem) and the second is ComboBoxQueryWorkign (the one without a problem).

I'm not sure why this is happening and I've tried comparing all the properties of both these combo boxes and changing some of them to see if I can eliminate the problem without any joy.

I use a very standard SELECT statement to pull the data for the combo box:

SELECT CountryID, CountryName FROM tblCountryInfo ORDER By CountryName

As I'm not sure what other properties contribute to this problem please let me know what you think I should post in terms of extra info.

Many thanks in advance.

Mohammed

 

[demicay2669]

Did you create your data type using a lookup wizard at table level? If so the lookup wizard gives you an option to select "Allow Multiple Values" which will give your combobox the checkboxes in your dropdown list. I'm not sure about other ways of doing it but thats what I did at one point in my db.

 

[Mohamster]

Thanks for your reply.

The data type is 'Text' in the table. At some point a lot of my fields had multiple values allowed at a table level, but I changed this when it was pointed out to me that this was bad practice.

I wonder if there is a glitch that is causing the previous setting to influence the form :/

 

[Mohamster]

Sorry just realised that my reply to demicay2669

"Did you create your data type using a lookup wizard at table level? If so the lookup wizard gives you an option to select "Allow Multiple Values" which will give your combobox the checkboxes in your dropdown list. I'm not sure about other ways of doing it but thats what I did at one point in my db."

​

was not clear. The data type was defined in a table, but the input is all conducted through forms as I realised it was better practice. However, in the past some of my data types were created through lookup wizards in the tables and I wonder if there is some glitch that is causing this problem going back to the lookup wizard.

 

[demicay2669]

I do believe when I changed my data types from lookup to another data type, I had to delete the original combo box off of my form and readd that field from the Add Existing Fields list.

 

[Mohamster]

Dunno why it never occurred to me to just remove the combo box and put a new one in D'OH! Let's see what happens

 

[Mohamster]

It's sorted!! Thanks Demicay2669!

I deleted the old combo box and created a new one and that solved it.

Still find it quite bizarre because none of the previous settings (for multiple values) were stored anywwhere either in the table or the form.

I wonder if anyone could comment on this glitch?

 

[David R]

It's actually pretty common I think...changing the TABLE field doesn't necessarily change what the FORM expects the field to be. I think it may have to do with whether the form field was made through a wizard, too...