组合框搜索 [英] Combo box searching

问题描述

我有一个数据库，我想要一个表格从一个表中查找数据。


i目前有一个用于搜索的组合框，我想要一个文本框显示与搜索相关的信息


我怎么能这样做？有人可以帮帮我吗？

I have a database where i am wanting a form to lookup data from one table.

i currently have a combo box used for searching and i am wanting to have a text box display the information relating to the search

how am i able to do this? can someone please help me?

推荐答案

我有一个数据库，我想要一个表单从一个查找数据表。


i目前有一个用于搜索的组合框，我希望有一个文本框显示与搜索相关的信息


我怎么能这样做？有人可以帮帮我吗？

I have a database where i am wanting a form to lookup data from one table.

i currently have a combo box used for searching and i am wanting to have a text box display the information relating to the search

how am i able to do this? can someone please help me?

您要返回的是哪个字段？


在组合框的更新后事件中

me.mytextbox = dlookup（" field"，" yourtable"，" [yourfield] ="& me.yourcombo）

what field are you returning?

in the after update event of your combo box

me.mytextbox = dlookup("field","yourtable","[yourfield]=" & me.yourcombo)

您要返回的是哪个字段？

在您的组合框更新后事件中



me.mytextbox = dlookup（" field"，" yourtable"，" [yourfield] ="& me.yourcombo）

what field are you returning?

in the after update event of your combo box

me.mytextbox = dlookup("field","yourtable","[yourfield]=" & me.yourcombo)

感谢您的帮助。我使用目的地字段作为搜索条件，当选择目的地时，相应的fiedld的公里显示在文本框中。


i尝试了你给我的参数，但现在它告诉我，没有名为我的宏。


i对于我需要做什么一无所知

Thanks for the help. i am using a destination field as the search criteria, when the destination is selected the kilometres from the corresponding fiedld are displayed in the textbox.

i tryed the argument you gave me but it now it tells me that there is no macro named "me".

i am so clueless about what i need to do

感谢您的帮助。我使用目的地字段作为搜索条件，当选择目的地时，相应的fiedld的公里显示在文本框中。


i尝试了你给我的参数，但现在它告诉我，没有名为我的宏。


i我对我需要做的事情一无所知

Thanks for the help. i am using a destination field as the search criteria, when the destination is selected the kilometres from the corresponding fiedld are displayed in the textbox.

i tryed the argument you gave me but it now it tells me that there is no macro named "me".

i am so clueless about what i need to do

你有一个表格。

你的表格有一个组合框

你把我给你的查找代码放在更新事件后的组合框中

你输入了正确的名字吗？


你能粘贴你试过的代码吗？

you have a form.
your form has a combo box
you put the lookup code I gave you in the combo box''s after update event
you put the correct names in?

can you paste in the code you tried?

这篇关于组合框搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！