Select record in split form query result

[Fazered]

I have searched and search and I can't find the answer to this question when I thought it would be simple. Hopefully you can put me out of my misery!

I have a access 2007 split form with a series of search boxes and a query result window. Enter info into one or more of the search boxes, click search and you get the matching results in the query window below. That works fine but I want to work with the results of the query, how can I do this?

I was looking for the user to be able to select a record and then click a command button to open that record in a form. Or in another instance select a record in the result window, have the current from close and have the primary key passed to a another form which I use to open the split form.

I just can't see how to do it but I expect there are several ways. Happy to use VBA but my experience is with Excel VBA so I'm still getting used to the objects.

Thanks in advance!

 

[ajetrumpet]

is this kind of close to what you want to do....???

 

[Fazered]

Well Adam it has caused some head scratching here as decide how we want the database to work but it has certainly helped a great deal. I didn't consider using a form but as it has a VBA module to work with it certainly does have advantages.

We do lose the advantage that with the method we were using the search acted as a filter reducing the number of results as you added information. Could your version be edited to do the same?

Thanks for your help.

 

[ajetrumpet]

We do lose the advantage that with the method we were using the search acted as a filter reducing the number of results as you added information. Could your version be edited to do the same?

Attached is another version of the file I posted before. This one filters a subform based on multiple combo box selections. I think that was what you were asking, correct?

If so, this form might be of more use to you. Let me know...

 

[Fazered]

Thanks again Adam, I'm just looking how I can use this. Super helpful as ever.

Will post results.