下拉列表以打开表单 [英] Drop Down List to Open Forms

问题描述

嘿〜

这是Annabelle再次非常感谢那些回答我之前VBA问题的人。拯救了我的生命很多次~~


这次我正在制作一个下拉列表......打开用户想要的表格。我很难将这些表单名称与OpenForm表达联系起来。


我的代码是这样的：

Hey~
It''s Annabelle again and really appreciate for people who answered my previous VBA questions. Saved my life a lot of times~~

This time I am working on a drop down list... which opens forms that users desire. Im having difficulty linking those form names with the OpenForm commend.

The code I had is like this:

展开 | 选择 | Wrap | 行号

推荐答案

请更具体地说明你的问题Annabelle。出了什么问题？

Please be more specific as to your problem Annabelle. What goes wrong where?

我想要做的只是通过下拉列表在我当前的数据库中打开表单。首先，我想将表单名称附加到下拉列表中，下一步我想将这些名称链接到相应的表单，因此在更新下拉列表时，我会得到正确的表单来打开。


当我运行此代码时，错误消息显示为表单名称1拼写错误或指的是不退出的表单。并且它突出显示了DoCmd.OpenForm。 line ..

What I am trying to do is simply open forms in my current database through drop down list. First I want to attach form names onto the drop down list, and next step I want to link those names to its corresponding forms, so when update the drop down list, I would get the right form to open up.

When I ran this code, a error message shows as " The form name ''1'' is misspelled or refers to a form that doesn''t exit. And it highlighted the "DoCmd.OpenForm" line..

那么，你有一个名为1的表单吗？

Well, do you have a form that is named 1?

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