使用模态或弹出窗口打开表单 [英] Open Form with Modal or Popup Window

问题描述

为此，我有一个数据表，其中列出了每条记录的ID和其他信息.到目前为止，我已经找到了一些VBA代码，这些代码将打开每个ID作为超链接并将其传递给另一种形式.

Struggling a bit with this, I have a datasheet form which lists the ID and other info for each record. So far I have found some VBA code which will open each ID as a hyperlink and pass that into another form.

我遇到的问题是我希望在弹出窗口或模式窗口中打开表单，到目前为止我的代码是:

The problem I have is I wanted the form to open in a popup or modal window, my code so far is:

Private Sub ID_Click()
    Dim varWhereClause As String
    varWhereClause = "ID = " & Me!ID
    DoCmd.OpenForm "Copy Of test", , , varWhereClause
End Sub

推荐答案

DoCmd.OpenForm "Copy Of test", , , varWhereClause, ,acDialog

尽管这将是弹出窗口和模式.

Though this will be pop-up and modal.

这篇关于使用模态或弹出窗口打开表单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！