query result in text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

There are similar questions in this forum, although none seemed to be
specifically what i am after. I have a form with a text box (text6), an
action button (runsearch), and a list box (list3). My goal is to have the
text entered in the text box be used as the criteria for selecting the list
of variables displayed in the list box. I have constructed a query that
performs an open ended search (where units.description = "*" &
[forms]![search]![text6] & "*") which works, but presents results in table
form. I would like them to be presented in the list box, and generated by
clicking the action button. Also, I would like the list box to remain empty
until filled by the query results. Please help....
 
Well, you're half way there. Use the search query as the rowsource for your
listbox. And requery the listbox(list3) in either the AfterUpdate event of
the textbox(text6), or in the commandbutton's Click event.

HTH,
Brian
 
Thanks for the help...Turns out I solved it on my own, however. Didnt need
the search button, just requeried the listbox after update in the text.



Brian Bastl said:
Well, you're half way there. Use the search query as the rowsource for your
listbox. And requery the listbox(list3) in either the AfterUpdate event of
the textbox(text6), or in the commandbutton's Click event.

HTH,
Brian

polisci grad said:
There are similar questions in this forum, although none seemed to be
specifically what i am after. I have a form with a text box (text6), an
action button (runsearch), and a list box (list3). My goal is to have the
text entered in the text box be used as the criteria for selecting the list
of variables displayed in the list box. I have constructed a query that
performs an open ended search (where units.description = "*" &
[forms]![search]![text6] & "*") which works, but presents results in table
form. I would like them to be presented in the list box, and generated by
clicking the action button. Also, I would like the list box to remain empty
until filled by the query results. Please help....
Click to expand...
Click to expand...
 
Back
Top