未绑定的嵌套子表单模拟连续表单 [英] Unbound Nested Subform Simulating Continuous Form

问题描述

需要一些帮助才能阻止我在这个圈子里转转....


有一个嵌套子表单（subform2），它模拟了
的连续表单父子窗体上的
记录。


Subform2有一行选项按钮加上两个文本字段或一个

复选框加上两个文本字段


我想将用户条目保存到基础表中。标签属性

为每个选项按钮，复选框或文本字段具有键的值

字段，用于保存到基础表的每条记录。


任何有关最佳方式的帮助/建议表示赞赏。


谢谢


Bob

Need some help to stop me going around in circles on this one....

Have a nested subform (subform2) which simulates a continuous form for the
record on the parent subform.

Subform2 has rows of either an option button plus two text fields or a
checkbox plus two text fields

Am wanting to save the user entries into an underlying table. Tag property
for each option button, check box or text field has the value of the key
field for each record to be saved to the underlying table.

Any help/suggestions on best way to do this appreciated.

Thanks

Bob

推荐答案

为什么要使用未绑定的表单，当你想将值保存到表格中时？


为什么要去当一个

绑定的一个在盘子上交给你时，试图模拟一个未绑定的连续形式的麻烦，并且需要接下来的努力才能开发出来？


最佳方式将使用绑定的连续子表单。


-

Allen Browne - Microsoft MVP。西澳大利亚州珀斯。

访问用户提示 - http：// allenbrowne.com/tips.html

回复群组，而不是mvps dot org的allenbrowne。


" Robert" < RO ******* @ bigpond.com>在消息中写道

news：vj ******************* @ news-server.bigpond.net.au ...

Why use an unbound form, when you want to save the values into a table?

Why go to the trouble of trying to simlate an unbound continuous form when a
bound one is handed to you on a platter and requires next to effort to
develop?

The "best way" will be to use a bound continuous subform.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Robert" <ro*******@bigpond.com> wrote in message
news:vj*******************@news-server.bigpond.net.au...

需要一些帮助来阻止我在这个圈子里转转....

有一个嵌套的子表单（subform2），它模拟了
记录的连续表格。父子窗体。

Subform2有一行选项按钮加两个文本字段或一个
复选框加上两个文本字段

我想将用户条目保存到基础表。标签属性
为每个选项按钮，复选框或文本字段具有要保存到基础表的每个记录的键值字段。

任何帮助/建议最好的方式来做到这一点赞赏。

谢谢

Bob

Need some help to stop me going around in circles on this one....

Have a nested subform (subform2) which simulates a continuous form for the
record on the parent subform.

Subform2 has rows of either an option button plus two text fields or a
checkbox plus two text fields

Am wanting to save the user entries into an underlying table. Tag property
for each option button, check box or text field has the value of the key
field for each record to be saved to the underlying table.

Any help/suggestions on best way to do this appreciated.

Thanks

Bob

Allen，

开始使用绑定子表单，但切换到使用未绑定子表单

更好的错误控制，更多控制保存记录（
$ b $上的单个按钮） b父子窗体）以及更加用户友好的数据捕获（选项按钮&

复选框而不是连续子窗体上的组合框）。


父子窗体"项目" （一）细节和嵌套子表格有（很多）

" Products"可以通过选项按钮或复选框和布局选择

表单不是每行一个记录（产品）。


" Allen Browne <铝********* @ SeeSig.Invalid>在消息中写道

news：43 ********************** @ per-qv1-newsreader-01.iinet.net.au ...

Allen,

Started with a bound subform but switched to using an unbound subform for
better error control, more control over saving records (single button on
parent subform) and for more user friendly data capture (option buttons &
check boxes rather than combo boxes on continuous subform).

Parent subform has "Project" (one) details and nested subform has (many)
"Products" that can be selected via option buttons or check boxes and layout
of the form is not on a one record (Product) per row basis.

"Allen Browne" <Al*********@SeeSig.Invalid> wrote in message
news:43**********************@per-qv1-newsreader-01.iinet.net.au...

当你想将值保存到表格中时，为什么要使用未绑定的表单？

为什么要在尝试模拟未绑定的连续表单时遇到麻烦？
一个有约束力的人会在盘子上交给你，需要接下来的努力才能发展？

最佳方式将使用绑定的连续子表单。

-
Allen Browne - Microsoft MVP。西澳大利亚州珀斯。
访问用户提示 - http://allenbrowne.com/ tips.html
回复群组，而不是在mvps dot org的allenbrowne。

罗伯特 < RO ******* @ bigpond.com>在消息中写道
新闻：vj ******************* @ news-server.bigpond.net.au ...

Why use an unbound form, when you want to save the values into a table?

Why go to the trouble of trying to simlate an unbound continuous form when
a bound one is handed to you on a platter and requires next to effort to
develop?

The "best way" will be to use a bound continuous subform.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Robert" <ro*******@bigpond.com> wrote in message
news:vj*******************@news-server.bigpond.net.au...

需要一些帮助来阻止我在这个圈子里绕圈....

有一个嵌套子表单（subform2），它模拟父子表单上记录的连续表单。 br />
Subform2有一行选项按钮加上两个文本字段或一个
复选框加上两个文本字段

我想将用户条目保存到基础表中。标签
属性为每个选项按钮，复选框或文本字段的值为
每个记录的关键字段要保存到基础表。

任何帮助/建议最好的方式来做到这一点赞赏。

谢谢

Bob

Need some help to stop me going around in circles on this one....

Have a nested subform (subform2) which simulates a continuous form for
the record on the parent subform.

Subform2 has rows of either an option button plus two text fields or a
checkbox plus two text fields

Am wanting to save the user entries into an underlying table. Tag
property for each option button, check box or text field has the value of
the key field for each record to be saved to the underlying table.

Any help/suggestions on best way to do this appreciated.

Thanks

Bob

你的问题是什么？

你想保存一些价值吗？

你不想这样做的方式吗？


你当然比一方面设计Access的那些僵硬的人好一些，但另一方面，你不知道如何解决这个问题？b $ b简单问题？极好！恭喜！


所以请保存。如果它们是新的，请使用INSERT INTO查询。如果不是，请使用UPDATE

查询。

有什么问题？

What''s your question?
You want to save some values?
And you don''t want to do it the Access way?

You, of course, are way better than those stiffs who designed Access on
the one hand, but on the other hand, you don''t know how to solve this
simple problem? Fabulous! Congratulations!

So save them. Use an INSERT INTO query if they''re new. Use an UPDATE
query if they''re not.
What''s the problem?

这篇关于未绑定的嵌套子表单模拟连续表单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！