在弹出窗口中显示记录集 [英] Display recordset in popup

问题描述

我有一个Access 2003应用程序，我在表中搜索带有值的记录（通过输入框给出）。


如果只有一条记录，我想以当前的形式转移到它。


如果我想要多条记录弹出一个表单，列出找到的记录，允许用户选择一个记录并以第一种形式加载它。


我有一切都在搜索（这意味着我可以判断是否有1个或多个记录匹配）...我需要的是找出要放入我的IF语句中转到或弹出的内容。

如果LnCount> 1然后



Else



结束如果

我知道这些是基本的questoins，但我我是一个MSSQL极客和Access是如此不同（据我所知）


提前谢谢。

解决方案

在我看来，你的结构更像是：

展开 | 选择 | Wrap | 行号

在Access中执行此类操作的更典型方法是级联组合框。如果您认为这可能有用，请查看表格上的示例过滤。

在我看来，你的结构更像是：

展开 | 选择 | Wrap | 行号

I have an Access 2003 app where I am searching a table for records with a value (given via an inputbox).

If there is only one record, I want to move to it in the current form.

If there are multiple records I want to popup a form listing the records found to allow the user to select a record and load it in the first form.

I have everything working on the search (meaning I can tell if there is 1 or more than one records matching)...all I need is to figure out what to put into my IF statement to goto or popup.

If LnCount > 1 Then


Else


End If

I know these are rudimentary questoins, but I am a MSSQL geek and Access is so different (as far as I can tell)

Thanks in advance.

解决方案

It seems to me your structure would be more like :

Expand|Select|Wrap|Line Numbers

A more typical way of doing something like this in Access would be to have cascaded Combo-Boxes. If you think this may work for you have a look in Example Filtering on a Form.

It seems to me your structure would be more like :

Expand|Select|Wrap|Line Numbers

这篇关于在弹出窗口中显示记录集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！