如何通过输入Zip自动填充城市和州字段？ [英] How can I autofil the City and State fields by entering a Zip?

问题描述

我试图通过输入邮政编码为我的数据库的城市和州字段创建自动文件。我尝试了一些不同的东西，但它没有正确填充。我从大学开始就没有编写程序，所以我不太了解我的语言，我似乎无法弄明白。如果有人有任何想法，我将非常感激。

Im trying to create an autofil for the city and state fields of my database by just entering a zip code. I have tried a few different things but it doesnt populate correctly. I haven''t had to write programming since college so Im not very up to date on my language and I cant seem to figure it out. If anyone has any ideas, I would really appreciate it.

推荐答案

假设您有一个存储城市，州和邮政编码信息的表，那么在更新后邮政编码控件的事件：

Assuming you have a table that stores City, State, and Zip Code information, then in the After Update event of the Zip Code control:

展开 | 选择 | Wrap | 行号

假设你有一个存储City，State和Zip Code信息的表，然后在Zip Code控件的After Update事件中：

Assuming you have a table that stores City, State, and Zip Code information, then in the After Update event of the Zip Code control:

< SP an class =codeLinkonclick =Blur（this，this.parentNode.parentNode，getChildren（this），true）;>展开 | 选择 | Wrap | 行号

您必须尝试将其放入属性中。您需要做的是将After Update事件属性设置为[Event Procedure]并将代码放在Visual Basic编辑器中的模块中。

You must be trying to put it in the properties. What you need to do is set the After Update event property to [Event Procedure] and place the code in the form''s module in the visual basic editor.

这篇关于如何通过输入Zip自动填充城市和州字段？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！