Knowing a great deal is not the same as being smart; intelligence is not information alone but also judgement, the manner in which information is coordinated and used.
I was watching your multi-field search form video, and at the end you mentioned opening another form after running the query. Once I get the query results, I need to be able to open a result. (As you can with a list form). How do I do that?
If you need the search results to show up in a form, just make a form based on the query that this Tip produces, and in your code, instead of OpenQuery, use OpenForm. Now if you want to click on a result in that list, you can either use Continuous Forms and a GO button, or instead feed the results into a ListBox on that form (my personal favorite) and then an OnDoubleClick event can open another form.
Austin RitnerOP
@Reply 6 years ago
Ok I've got the results showing up in the listbox, but when I try and double click, it opens ALL the records not the one I specifically want. Would a listform be better in this instance?
You need to specify a WHERE condition in your OpenForm command to show just a specific record.
Austin RitnerOP
@Reply 6 years ago
I've tried over a dozen more times, and I still cant seem to get it. I dont understand what a WHERE condition is, the list box isn't opening what I want it to, I can't use a subform, the query keeps going to datasheet view..... I'm getting really frustrated, and need to take a break. My head is literally starting to hurt.
I figured it out. Made a listform and changed the record source to the query. Now whenever I type the search parameters the results show up in the subform and I can open the query results from there. Made it a wildcard criteria.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Multi-Field Search Form.
