具有检查框的Combobox多字段在保存，关闭和再次打开后变为简单的列表字段 [英] Combobox multiple field with checker boxes turns into a simple list field after saving, closing and opening again

问题描述

亲爱的所有人，

使用MS Access 2010和专业版2013.

在表格中，我有字段"国家/地区"。这是一个有多个选项的组合框。组合框在表格中表现得非常好。

我从这张表中创建了一个表格。

当使用选项"添加现有字段"时并由doulbe点击"国家"字段，表单上添加的组合框多个工作正常。然后我保存，关闭并重新打开（甚至改变几次视图模式从布局到设计
和窗体视图）：组合框不再有检查框："控制源"和"控制源"。组合框的属性字段从"国家"自动转向。到"countries.value"，我无法将其编辑回"国家/地区"。没有
访问权限将其更改回"countries.value"

请注意，通过选择表格创建新表单，然后"创建表单"即使在保存并关闭表单或更改视图后，组合框也能正常工作。

任何想法？ （而不是从头开始重新创建表单！）

谢谢

解决方案

Hi Steed75，

>>我无法将其编辑回"国家/地区"。没有Access将其更改回"countries.value"

我使用您的描述进行了测试，但我未能重现您的问题。我的组合框数据源没有改变，它有检查框。我手动将控制源更改为"countries.value"，并且检查框将消失。但是我可以用b $ b来改变它。用"无法编辑回来"是什么意思？您的意思是，如果您将其更改回来，Access会再次将其更改为"countries.value"吗？如果是这样，我假设可能有一些代码来更改控制源。

我建议您查看代码是否有一些代码来更改控制源，或者您可以更改国家/地区组合框控件的名称，控制国家组合框控制源，然后再次测试。

最好的问候，

爱德华

Dear all,

With MS Access 2010 and Professional 2013.

In a table I've field "Countries" which is a combobox with multiple sélections. The combobox works perfectly well in the table.

I've a form created from this table.
When using the option "Adding existing field" and by doulbe clicking on the "Countries" field, the combobox multiple added on the form works fine. Then I save, close and reopen (or even change several times the view mode from Layout to Design and Form views): the combobox has not checker boxes anymore: the "control source" property field of the combobox turned automatically from "countries" to "countries.value", and I cannot edit it back to "countries" without Access changing it back to "countries.value"

Note that when creating a new form by selecting the table, and "create a form" the combobox works perfectly fine even after saving and closing the form, or changing the views.

Any ideas? (instead of recreating the form from scratch!)

Thanks

解决方案

Hi Steed75,

>> I cannot edit it back to "countries" without Access changing it back to "countries.value"

I made a test with your description, but I failed to reproduce your issue. My combobox datasource did not change, and it has checker boxes. I change it the control source to "countries.value" manually, and the checker boxes would disappear. But I am able to change it back. What do you mean with "cannot edit it back"? Did you mean if you change it back, the Access would change it to "countries.value" again? If so, I assume there might be some code to change the control source.

I suggest you check your code whether there is some code to change the control source or you could change the name of countries combobox control, control source of countries combobox control, and then test again.

Best Regards,

Edward

这篇关于具有检查框的Combobox多字段在保存，关闭和再次打开后变为简单的列表字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！