重新排列子表单 [英] Rearrange subform

问题描述

我有一个包含两个子表单的表单。

左手子表单显示10条记录。

右侧子表单显示10条记录。

每个子表单都是从它自己的表/查询中填充的。


我希望能够勾选左右子表单中的方框并使用右手子表格随机播放以便记录匹配。


我感谢大家的帮助。


戈登

I have a form with two subforms.
The left hand subform shows 10 records.
The right hand subform shows 10 records.
Each subform is populated from its own table/query.

I want to be able to tick boxes in the left and right subforms and have the right hand subform shuffle so that the records match.

I thank you all for any help.

Gordon

推荐答案

对问题的更清楚的解释将有助于人们理解。

A clearer explanation of the problem would help people to understand.

感谢回复NEO。


我的表单有subform1和subform2。 />

Subform1在左边。

Subform2在右边，


两个子表单都设置为连续表格。


我想在显示的记录中有一个勾选框或类似的东西。


所以我勾选 subform1和tick中的记录子窗体2中的记录。


然后在命令按钮上单击，我希望对子窗体2（在右侧）进行排序或排列，以便两者中的记录并排排列。

------------------------------------------- -------------------------------------------------- ------------------

我不知道怎么解释得更好但是这里去了！


b左边10条记录。

右边10条记录。


在左边的第一条记录中勾选一个方框，


做出选择后，按下命令按钮。


现在右边的记录被重新排列，以便左边的记录和右边的记录排成一行。


然后我在左边的第二个记录中勾选一个方框。


向下看右手记录并勾选所选记录中的勾选框。


做出选择后，pres sa命令按钮。


现在右边的记录被重新排列，以便左边的记录和右边的记录排成一行。


我为展会上的所有记录做了这个。

Thanks for reply NEO.

My form has subform1 and subform2.

Subform1 is on the left.
Subform2 on the right,

Both subforms are set for continuous forms.

I want to have a tick box or similar in the records showing.

So I "tick" a record in subform1 and "tick" a record in subform2.

Then on a command button click, I want subform2 (on the right) to be sorted or arranged so that the records in both line up alongside each other.
---------------------------------------------------------------------------------------------------------------
I don''t know how to explain better but here goes!

10 records on the left.
10 records on the right.

Tick a box in first record on the left,

Look down right hand records and tick the tick box in the record of choice.

After making a selection, press a command button.

Now the records on the right are rearranged so that the record on left and record on right are lined up.

I then tick a box in second record on left.

Look down right hand records and tick the tick box in the record of choice.

After making a selection, press a command button.

Now the records on the right are rearranged so that the record on left and record on right are lined up.

I do this for all records on show.

对不起，但我认为没有办法做到这一点。


我有兴趣知道左边的数据和右边的数据是否有任何共同的信息或字段。您可以重新排序数据集，并可以限制数据集的内容。这两种技术都可用于匹配数据。

不幸的是，您似乎需要以随机（未指定）的顺序重新组织数据，唯一的必要条件是单个记录必须进入指定的序号位置（必须在列表中的第n位）。

Sorry, but I don''t think there''s any way of doing this.

I was interested in knowing if the data on the left and the data on the right had any info or fields in common. You can re-sort datasets and you can restrict the contents of datasets. Both of these techniques can be used to match up data.
Unfortunately, you seem to need reorganising of the data in a random (unspecified) order, with the only requisite being that an individual record must come in the specified ordinal position (it must come nth in the list).

这篇关于重新排列子表单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！