连续形式 - 控制行为 [英] Continuous form - control behaviour

问题描述

大家好，


我有一个带有标签，文本框和两个切换按钮的连续表格（不是子表格）。当我单击记录的切换按钮时，该切换按钮会更改表单中的所有记录。 Web搜索表明连续表单上的未绑定控件都是一个控件的相同实例，但此按钮绑定到查询中的一个字段。


如何只获取切换按下我要改变的按钮？


A2k3：WinXP

Hi all,

I have a continuous form (not a subform) with a label, text box and two toggle buttons. When I click the toggle button for a record, that toggle button changes on ALL the records in the form. Web searches indicate that unbound controls on a continuous form are all the same instance of one control, but this button is bound to a field in the query.

How do i get only the toggle button that I press to change?


A2k3:WinXP

推荐答案

首先要做的是双重检查它实际上是你想的那样。控制源中的字段是什么？它必须属于哪种领域？需要成为是/否字段。


欢迎来到字节！


Linq ; 0）>

First to do would be to doublecheck that it actually bound as you think. What field is in the Control Source? What kind of field is it bound to? Needs to be a Yes/No field.

Welcome to Bytes!

Linq ;0)>

正如Linq已经指出的那样（当然非常外交），听起来控件实际上并没有受到约束。


请确认你找到了什么，以便我们知道你现在一切都好。

As Linq has already indicated (very diplomatically of course) it sounds like the control is not actually bound.

Please confirm what you find so that we know you''re all ok now.

G''day Linq，NeoPa

感谢回复，我是gmt + 8，所以当我明天上班时，我会仔细检查并报告。在过渡期间...


是的，我很确定控制是有约束力的。该字段是IsElected（它是一个议会选举数据库），是/否。我的担保源于这样一个事实：我把控制源拿出来并把它放回去 - 至少我认为我把它放回去了，现在我自己怀疑:) - 检查我没做任何愚蠢的事。有趣的是，似乎只有我单击切换按钮的记录在数据库中被更改，所以这是一个视图而不是模型问题，但我离题了。


一个我觉得我做错了（我只想到火车回家的事情）就是我已经改变了行为不端的查询（和基础表），从我使用的原始版本和由调用问题表单的表单使用。两个查询都使用相同的ID字段来检索它们的数据，因此这可以（？）解释它以这种方式运行。那个合理化_应该让后脑今晚得到休息:-)


正如所承诺的那样，我将在上午报告（嗯，也许是你下午晚些时候的linq，否则明天就是你和NeoPa）有效性，以及是否更改调用形式的查询以匹配此功能。


欢呼

mcalex


外交：大声笑，我在这里看过一些新帖并完全理解

G''day Linq, NeoPa

thanks for replies, i''m gmt+8, so i''ll double check when I get in to work tomorrow, and report. In the interim ...

Yes, I''m pretty sure the control is bound. The field is IsElected (it''s a council elections db) and is Yes/No. My surety here stems from the fact I''ve taken the control source out and put it back in - at least i think i put it back in, now i''m doubting myself :) - to check i didn''t do anything stupid. Interestingly, it seems that only the record that I click the toggle button on is changed in the database, so it''s a view rather than a model problem, but I digress.

One thing I think i''ve done wrong (i only thought of this on the train going home) is that i''ve changed the query (and the underlying table) in the misbehaving form, from the original that I was using and which is used by the form that calls the problem form. Both queries use the same ID field to retrieve their data, so this may(?) explain it behaving in this manner. That rationalisation _should_ let the hindbrain get some rest tonight :-)

As promised will report back in the am (um maybe your late pm linq, otherwise tomorrow for you and NeoPa) about the boundedness, and whether changing the calling form''s query to match this has any effect.

cheers
mcalex

diplomacy: lol, i''ve seen some of the newb postings here and fully understand

这篇关于连续形式 - 控制行为的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！