动态访问表 [英] Dynamic Access Form

问题描述

我在Access 2003中创建一个动态表单的形式打开组合框基于表的创建每一次的关键词。我的code有麻烦删除旧箱（或它们的标签，我不知道）和之后的第一个无孔不入被挂在重复的名称（运行时错误'2450'）。

I am creating a dynamic form in Access 2003. Each time the form is opened combo boxes are created based on table of "keywords." My code is having trouble deleting old boxes (or their labels, I'm not sure) and every opening after the first gets hung up on duplicate names (Run-time error '2450').

其次，结合表持检查的关键字将填补了在低量有限。

Secondly, junction table holding the "checked" keywords will fills up at a low finite amount.

第三，我无法弄清楚如何填充的基础上结合表记录的组合框。当窗体加载的箱子总是选中。

Thirdly, I can't figure out how to populate the combo boxes based on the junction table records. When the form is loaded the boxes are always unchecked.

感谢您的帮助！

推荐答案

我会建议采用连续窗体绑定到结合表，每个关键字和主要记录的一个记录。该kwyword将是一个组合框。确保你有一个基于foriegn主记录键并在路口表foriegn关键字关键既是欺骗检查指数。

I'd suggest using a continuous subform bound to a junction table with one record per keyword and main record. The kwyword would be a combo box. Ensure you have a "dupe check" index based on both the foriegn main record key and the foriegn keyword key on the junction table.

这篇关于动态访问表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！