将表单打开到特定记录 [英] Opening a form to a specific record
问题描述
大家好,
我有一个名为customer_frm的表格其中有很多记录。
我希望有一个表格,其中有一个组合框,列出了所有
的客户,以及一个打开&b按钮的按钮。 customers_frm"我在组合框中选择的具体
记录。
我可以通过访问的搜索功能来做到这一点,但它是
对于简单的访问用户来说并不是非常友好。
你有什么想法吗?
谢谢,
Mike
Hi all,
I have a form called "customer_frm" with many records in it.
I would like to have a form that has a combobox listing all the
customers, and a button that open the "customers_frm" to the specific
record I have chosen in the combobox.
I could do this through the Search function of access, however it is
not really friendly for simple users of access.
Do you have an idea?
Thanks,
Mike
推荐答案
5月14日,4:13 * am,casan.m ... @ gmail.com写道:
On May 14, 4:13*am, casan.m...@gmail.com wrote:
大家好,
我有一个名为customer_frm的表格其中有很多记录。
我希望有一个表格,其中有一个组合框,列出了所有
的客户,以及一个打开&b按钮的按钮。 customers_frm"我在组合框中选择的具体
记录。
我可以通过访问的搜索功能来做到这一点,但它是
对于简单的访问用户来说并不是非常友好。
你有什么想法吗?
谢谢,
迈克
Hi all,
I have a form called "customer_frm" with many records in it.
I would like to have a form that has a combobox listing all the
customers, and a button that open the "customers_frm" to the specific
record I have chosen in the combobox.
I could do this through the Search function of access, however it is
not really friendly for simple users of access.
Do you have an idea?
Thanks,
Mike
你的按钮会做一个
docmd.openform" customers_frm" ,,,,,
openform的一个参数是''where''子句,你会在那里用
指定
" customerId =''' &安培; cboCustomer(0)& "''"
其中cboCustomer是你的组合框的名称
your button will do a
docmd.openform "customers_frm",,,,,
one of the parameters of openform is a ''where'' clause, there you''ll
specify
"customerId = ''" & cboCustomer(0) & "''"
where cboCustomer is the name of your combobox
谢谢...我会试试它现在。
Thank You... I am gonna try it right now.
尝试使用向导在表单上构建一个搜索组合框。
结果将是一个列出所有客户的组合框,当你选择一个客户时,表格将显示该记录。
-
Albert D. Kallal(访问MVP)
加拿大艾伯塔省埃德蒙顿
pl ***************** @ msn.com
这篇关于将表单打开到特定记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!