Usable search form - replicate search in datasheet view

[sstiebinger]

Thank you for taking the time to look, here's my issue:

I have a customer form in split view that works well, however, I'd like to make search the list of customers easier.

Currently we use the search box in the datasheet portion of the split form, which does an acceptable job, but there are a few issues, one being that the user can't specify which fields to search against, the second being that it's small and un-noticeable.

I created a search form using the tutorial here:
http://www.datapigtechnologies.com/f...earchform.html

And that gives me exactly the capabilities I want in a search... the problem is, how do I then continue with what the query has returned?

That is... I run the query based on the form, and it returns the list of customers... but now I want to, for instance, double click on the customer I want and open the customer form at that user...



I'm new to access, so I'm not quite sure how to do this... my impression is that I need to have a new form being populated by the results of that query???
I feel like I'm close, but can't see the forest for the trees.

Thanks again for your input.

[ranman256]

You have search form with the Box to find. The query of the form uses the txt box as a parameter.
on btnFind click, the query for the form (continuous form) is refreshed.
Select a record in the result list. Another button on the form can open the detail.
on btnDetail click:
docmd.openform "frmDetail",,me.RecID

[sstiebinger]

I'm not sure I understand... so I've got the form with the search boxes, and the search button... and I also display the results on that same form.... how do I do that? or do I display the results in the subform and pass the query to the subform to refresh?

Sorry... an example may help me to visualize that, if you wouldn't mind.