下拉A，B，C ......跳转到名字 [英] Dropdown A, B, C... to jump to names

问题描述

您好，


我正在使用Access 2002.我创建了一个存储名称的数据库。

现在我想添加一个包含字母表的下拉菜单，意思是A，B，C ... Y，Z。例如，通过选择H，表格应该跳转到第一个名字。数据库以H开头。

我尝试了以下代码，但对表单没有影响。什么也没发生。

[fullname]是数据库和表格中的一个字段。


感谢您的帮助。


Tobias

Hello,

I am using Access 2002. I created a database where names are stored.
Now I want to add a drop down menu which contains the alphabet, means A, B, C... Y, Z. By selecting H for example, the form should jump to the first name in the database starting with H.
I tried the following code but there was no effect on the form. Nothing happened.
[fullname] is a field in the database as well as in the form.

Thank you for helping.

Tobias

展开 | 选择 | Wrap | 行号

推荐答案

我很困惑！将AutoExpand设置为Yes（默认值）的标准组合框将带您到以H开头的名字。


Hitting< Enter>然后将检索该记录，你将在H'中！

I''m confused! A standard combobox, with AutoExpand set to Yes (the default) will take you to the first name beginning with a H.

Hitting <Enter> will then retrieve that record, and you''ll be in the H''s!

你好，


我正在使用Access 2002.我创建了一个存储名称的数据库。

现在我想添加一个包含字母表的下拉菜单，意思是A，B，C ... Y，Z。例如，通过选择H，表格应该跳转到第一个名字。数据库以H开头。

我尝试了以下代码，但对表单没有影响。什么也没发生。

[fullname]是数据库和表格中的一个字段。


感谢您的帮助。


Tobias

Hello,

I am using Access 2002. I created a database where names are stored.
Now I want to add a drop down menu which contains the alphabet, means A, B, C... Y, Z. By selecting H for example, the form should jump to the first name in the database starting with H.
I tried the following code but there was no effect on the form. Nothing happened.
[fullname] is a field in the database as well as in the form.

Thank you for helping.

Tobias

展开 | 选择 | Wrap | 行号

试试这个：

Try this:

展开 | 选择 | Wrap | 行号

这篇关于下拉A，B，C ......跳转到名字的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！