过滤绑定的表单字段 [英] Filtering form fields that are bound

问题描述

嗨


我想通过其中一个字段SW_ID过滤连续表单（FRM_SUPPT）上的记录。


FRM_SUPPT已经一个文本框（绑定到SW_ID）和两个绑定的下拉列表。这三者是联合主键。我需要能够查看数据并在此表单中输入。


现在，SW_ID文本框的默认值来自上一个表单（FRM_SOFTWARE）上的文本框。


在FRM_SOFTWARE表单上，当您单击按钮时，它会打开FRM_SUPPT并弹出默认值，以便我可以输入新数据。


但是它也会显示在此表单中输入的所有记录，其中包含SW_ID值​​不同的记录。


我希望能够输入数据，同时能够查看具有相同SW_ID值​​的所有记录，但我不希望能够看到具有不同值的记录。


帮助非常感谢


谢谢

HlebforPM

解决方案

您好


我想通过其中一个字段SW_ID过滤连续表格（FRM_SUPPT）上的记录。


FRM_SUPPT有一个文本框（绑定到SW_ID）和两个绑定的下拉列表。这三者是联合主键。我需要能够查看数据并在此表单中输入。


现在，SW_ID文本框的默认值来自上一个表单（FRM_SOFTWARE）上的文本框。


在FRM_SOFTWARE表单上，当您单击按钮时，它会打开FRM_SUPPT并弹出默认值，以便我可以输入新数据。


但是它也会显示在此表单中输入的所有记录，其中包含SW_ID值​​不同的记录。


我希望能够输入数据，同时能够查看具有相同SW_ID值​​的所有记录，但我不希望能够看到具有不同值的记录。


帮助非常感谢


谢谢

HlebforPM

在公开活动中试用此代码你的表单：

展开 | 选择 | Wrap | 行号

嗨


我想通过其中一个字段SW_ID来过滤连续表格（FRM_SUPPT）上的记录。 br />

FRM_SUPPT有一个文本框（绑定到SW_ID）和两个绑定的下拉列表。这三者是联合主键。我需要能够查看数据并在此表单中输入。


现在，SW_ID文本框的默认值来自上一个表单（FRM_SOFTWARE）上的文本框。


在FRM_SOFTWARE表单上，当您单击按钮时，它会打开FRM_SUPPT并弹出默认值，以便我可以输入新数据。


但是它也会显示在此表单中输入的所有记录，其中包含SW_ID值​​不同的记录。


我希望能够输入数据，同时能够查看具有相同SW_ID值​​的所有记录，但我不希望能够看到具有不同值的记录。


帮助非常感谢


谢谢

HlebforPM

嗨

怎么样

展开 | 选择 | Wrap | 行号

感谢您的回复。


我已经尝试了但它似乎没有工作，所有具有不同SW_ID值​​的条目仍然会弹出。


我不确定我做得对。绑定到SW_ID的文本框称为txtSwId，因此我键入：

展开 | 选择 | Wrap | 行号

Hi

I want to filter records on a continuous form(FRM_SUPPT) by one of the fields, SW_ID.

FRM_SUPPT has a text box ( bound to SW_ID) and two drop-down lists that are bound also. The three together are joint primary keys. I need to be able to view data and enter it on this form.

Now the default value of the SW_ID textbox is from a textbox on the previous form(FRM_SOFTWARE).

On FRM_SOFTWARE form, when you click on a button it opens up FRM_SUPPT and the default value pops up so i can enter new data.

However it also shows all the records entered in this form with ones with a different value for SW_ID.

I want to be able to enter data while at the same time being able to see all records that have the same value of SW_ID, but I do NOT want to be able to see records with a different value.

Help would be greatly appreciated

Thanks
HlebforPM

解决方案

Hi

I want to filter records on a continuous form(FRM_SUPPT) by one of the fields, SW_ID.

FRM_SUPPT has a text box ( bound to SW_ID) and two drop-down lists that are bound also. The three together are joint primary keys. I need to be able to view data and enter it on this form.

Now the default value of the SW_ID textbox is from a textbox on the previous form(FRM_SOFTWARE).

On FRM_SOFTWARE form, when you click on a button it opens up FRM_SUPPT and the default value pops up so i can enter new data.

However it also shows all the records entered in this form with ones with a different value for SW_ID.

I want to be able to enter data while at the same time being able to see all records that have the same value of SW_ID, but I do NOT want to be able to see records with a different value.

Help would be greatly appreciated

Thanks
HlebforPM

Try this code in the open event for your form:

Expand|Select|Wrap|Line Numbers

Hi

I want to filter records on a continuous form(FRM_SUPPT) by one of the fields, SW_ID.

FRM_SUPPT has a text box ( bound to SW_ID) and two drop-down lists that are bound also. The three together are joint primary keys. I need to be able to view data and enter it on this form.

Now the default value of the SW_ID textbox is from a textbox on the previous form(FRM_SOFTWARE).

On FRM_SOFTWARE form, when you click on a button it opens up FRM_SUPPT and the default value pops up so i can enter new data.

However it also shows all the records entered in this form with ones with a different value for SW_ID.

I want to be able to enter data while at the same time being able to see all records that have the same value of SW_ID, but I do NOT want to be able to see records with a different value.

Help would be greatly appreciated

Thanks
HlebforPM

Hi

How about

Expand|Select|Wrap|Line Numbers

Thanks for the reply.

I''ve tried it but it doesn''t seem to be working, all the entries with different values of SW_ID still keep popping up.

I''m not sure if I am doing it right. The text box that is bound to SW_ID is called txtSwId so I typed in:

Expand|Select|Wrap|Line Numbers

这篇关于过滤绑定的表单字段的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！