I'm using a form to display the results of my query. What I need is the results to be displayed with columns & rows(pretty much the way it looks after you run the query). But I need to be able to scroll through them if there is many and have the user be able to select anyone one of the records & based on the selection have it look up & search an image table automatically based on a value(in a cell)in the record that has been selected in the subform1. I would like the results of that to be displayed in either another subform2 or perhaps a list box. The results would only return a value from one field but there could be a list of multiple drawings as a result.

Does that make any sense?
and do I need to use Subforms?
Is there other ways to accomplish this?

Any help would be greatly appreciated.

-dale

I've managed to return the value of the paticular record in the subform1 I'm selecting but how do I get my subform2 to update when I click on my cmdFind button?

Did you set the master/child fields?