User Search defined by text box

[Guest]

I did some reasearch and found this post
------------------------
By: KARL DEWEY
Try this --
In the header of the form put unbound textbox, combox, or listbox to enter
or select the criteria. Add a command button to requery the query that is
the record source for the form.
In the query add criteria from each of the textbox, combox, or listbox from
the form header like --
Like "*" & [Forms]![YourFormName]![YourTextBox] & "*"

If you have entered 'be' in the textbox you will get Abe, Abel, Betty, Maybe.

If you do not use the leading or trailing wildcards you will limit what you
pull.
---------------------------


How would i create a query button to requery the form based on the users
input?
I have tried adding a comand button that runs a query.... but it opens a new
window in spreadsheet... I want the form that the button and text box are on
to be populated with the queried info.

Thanks,
Greg

 

[Albert D. Kallal]

Have you tried using the combo box wizard ?

tried placing a combo box at the top your form and use the wizard .

use the option that I want a find a record based on my input ...


the wizard will then build a search system for you.

 

[Guest]

but i just want a text box where the user types in the criteria and what
appears is the information... not a combo box.
Thanks

 

[Guest]

ok i figured it out after while playing with it... I added VB code to requery
the command after updat.

 

[Albert D. Kallal]

but i just want a text box where the user types in the criteria and what
appears is the information... not a combo box.
Thanks

O. K. do remember that the user can simply type in the criteria into the
combo box actually not have to drop down the combo box.

At this point it's really much the same as a text box anyway.....

there is some examples here

http://www.datastrat.com/DataStrat2.html

http://www.mvps.org/access/forms/frm0045.htm

And I give my whole idea on this concept here

http://www.members.shaw.ca/AlbertKallal/Search/index.html