自动填写表格

本文介绍了自动填写表格的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 29岁程序员，3月因学历无情被辞！ 我基本上有一个地址数据库，包括姓名，城市，省和国家。表格还包括这些字段，名称，城市，省份和国家/地区。一切都被送入一张桌子。我想知道是否有办法进行自动填充，这样如果用户以多伦多的身份进入城市，该省将自动显示为安大略省。我很确定这个问题的答案已经以不同的方式发布，但我无法找到它。请帮帮我谢谢！解决方案 您好。 以下代码将执行此操作。当然，表单控件，表字段和表本身的名称可能在您的数据库中有所不同。 展开 | 选择 | Wrap | 行号 你想在代码中添加多少if ... then语句？ 你想添加新的if ... 。每次添加新城市时都会发出声明吗？ 表查找有什么问题？ :)我只能猜测你必须避免使用Access权益的特殊原因。 ：）） i basically have an address database, consisting of name, city, province, and country. The form has these fields as well, name, city, province, and country. Everything is fed into one table. I want to know if there is a way to autofill, so that if the user were to enter the city as toronto, the province would automatically appear as ontario. im pretty sure the answer to this question has already been posted in a different way, but i just cant find it. please help me out thanks! 解决方案Hi.The following code will do it. Certainly the names of form controls, table fields and table itself may be different in your db. Expand|Select|Wrap|Line NumbersHow many if...then statements do you want to add to your code ?Would you like to add new if...then statement each time new city is added?What is wrong with table lookup? :) I can only guess what a special reason you have to avoid using of Access benefits. :)) 这篇关于自动填写表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！ 上岸，阿里云！