VBA，访问自动填写表格 [英] VBA, Access Auto Fill Form

问题描述

嘿，我正在尝试为正在使用的数据库编写一些VBA.
问题出在这里:

我有一个组合框，选择该组合框将自动填充其后的其余记录.

只需向正确的方向轻推即可！


详细信息:
组合框:CustomerID

需要自动填充的记录:
姓氏
姓
地址
邮政编码
电话
传真
电子邮件



谢谢.
-Sonos

Hey, i''m trying to code some VBA for a database i''m working on.
Here''s the problem:

I''ve got a combo box, which when selected will auto fill in the rest of the records following it.

Just need a nudge in the right direction!


Details:
Combo box: CustomerID

Records which need to auto fill:
Forename
Surname
Address
Postcode
Telephone
Fax
Email



Thanks.
-Sonos

推荐答案

您追求的是MS Access的查找表.

请使用以下URL查找有关此信息:

What you are after is MS Access''s Lookup-Tables.

Please use the following URL''s to find some information about that:

1. http://www.trigonblue.com/AccessLookup.htm [ http://www.articlesbase.com/databases-articles/using-a-lookup-table-in-microsoft-access -979261.html [ http://www .ehow.com/how_12375_look-values-one.html [ ^ ]
2. http://www.fabalou.com/Access /General/lookup_tables_lut.asp [

1. http://www.trigonblue.com/AccessLookup.htm[^]
2. http://www.articlesbase.com/databases-articles/using-a-lookup-table-in-microsoft-access-979261.html[^]
3. http://www.ehow.com/how_12375_look-values-one.html[^]
4. http://www.fabalou.com/Access/General/lookup_tables_lut.asp[^]

我希望这能朝着正确的方向前进.

-MRB

I hope this nudges you in the right direction.

-MRB

这篇关于VBA，访问自动填写表格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！