Search a query, post on form?

[D347HxD]

http://www.mediafire.com/?36bhszdxj6n810t

Above is my current database I am working on. As you can see, when you open the SearchF form it brigns up a bunch of search options and when you type something in, and click run query it runs it, and searching the SearchQ query for what you typed in. It launches the query, but how would I accomplish that to instead of launching the query it launches a form that has the query on it?

Better yet, how can I set it up so the query and search functions are on the same form?



Note: OrderT is the table being used, CustomerT is something I am playing around with.

[Dal Jeanis]

Put a subform control on the form, make the query the source of the subform, and refresh the subquery every time any of the search options are changed.

[D347HxD]

Put a subform control on the form, make the query the source of the subform, and refresh the subquery every time any of the search options are changed.

How would I go about refreshing the subquery every time any of the search options are changed?

[alansidman]

When you run your code for the execution of the query, add this line

me.requery

[D347HxD]

sorry, I am really new with Access. I don't quite understand what you mean. The only place I really have any code is on the query it self under criteria and under that I have:

Like "*" & [Forms]![SearchF]![BusinessName] & "*"

BusinessName being replaced with the other 14 text box names for the other search bars.

Under the button, I am using events. It uses OpenQuery, and CloseWindow (though since I now have the subquery attached to my form, I since removed the CloseWindow event.)

Where would I put the bit of code you gave me?

EDIT: Fooling around with everything I figured out where to put it and it now works! Woo! Though there is one more thing I need, on another topic (it does evolve the subquery + form though).

http://www.mediafire.com/?36bhszdxj6n810t

That is my current database. Once again, CustomerT isn't needed, ignore it for now. What I want is on SearchF, the add button. How would I set it up so when I write in the text boxes beside that, and push add it adds it to the OrderT for the query to be able to look up when you search later? It sounds simple, but I have no clue where to start.

[Dal Jeanis]

D3 - when you have a totally new question, please start a new thread. You'll get more/better attention.