Access-带where子句的打开表单 [英] Access- Open form with where clause

问题描述

我需要通过单击子表单记录名称来打开特定表单.子窗体中的名称显示为一个组合框，其中ID和Name为列.

I need to open a specific form by a click on a subform record name. The name in the subform is showed as a combobox with ID and Name as columns.

我确实是这样的:

Private Sub ID_Prodotto_DblClick(Cancel As Integer)
Dim Id As Integer
Id = Me.ID_Prodotto.Column.Value
DoCmd.OpenForm "Prodotto", , , "ID_Prodotto = " & Id
End Sub

但是Access要求我在记录上单击时手动插入ID字段值.我哪里错了?

But Access requires me to manually insert the ID Field Value as I click on the record. Where am I wrong?

推荐答案

它应显示为:

Id = Me!ID_Prodotto.Value

或者，如果您希望使用列号n中的值(第一个为0):

or, if you wish to use the value from column number n (0 is the first):

Id = Me!ID_Prodotto.Column(n)

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