VBA表单打开 [英] VBA for form open

问题描述

朋友们好，请任何人都可以解决我的问题


我在TrNo上使用了VBA，如下面的代码标签所示，以下表格是打开的，所以它不能正常工作打开BT_DepositEntryModify表单，否则无效。我认为只需要更改VBA代码，所以请重播如何在这种情况下提供VBA。我已将附加的dB和屏幕截图附加说明。


表格：

BT_DepositEntryModify

BT_WithdrawEntryModify

Hello friends, please can anyone solve my issue

I have used VBA on TrNo filed as per shown on Code Tag for below following forms open purpose so it is not working properly only open BT_DepositEntryModify form otherwise not working. I think just need to change VBA code so please replay how to give a VBA in this case. I have attached the dB and Screenshot with Explanation.

Forms:
BT_DepositEntryModify
BT_WithdrawEntryModify

展开 | 选择 | Wrap | 行号

推荐答案

你不知道我是什么！ID是在那里找到的值。在工作中我无法打开zip文件。你收到错误了吗？请解释一下。

You don''t tell what Me!ID is or the values found there. I can''t open zip files at work. Are you getting errors? Please explain.

感谢重播

没有错误，但在VBA代码中显示了两个类型的条件显示表单打开所以第一个是BT_DepositEntryModify表单这是工作好。

但是第二个是BT_WithdrawEntryModify形式，这个表单是无法打开的，当我点击TrNo时按照截图并在这个表格中也打开第一个BT_DepositEntryModify表格。

所以我需要根据TrNo字段要求打开第二个表格BT_WithdrawEntryModify表格。

Thanks for replay
There is no error but in the VBA code two type’s conditions shown for form opening so 1st one is BT_DepositEntryModify form this is working well.
But 2nd one is BT_WithdrawEntryModify form this form is can’t open when I click on TrNo as per screenshot and in this form place also open 1st one BT_DepositEntryModify form.
So I need to open 2nd form also BT_WithdrawEntryModify form as per TrNo field require.

是的，但你的代码依赖于ME.ID，因为你并没有分享那些领域中的价值，TrNo并不重要。

Yes, but your code is dependent upon ME.ID, and since you haven''t shared what values are found in that fields, TrNo is immaterial.

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