G
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
------------------------
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