Help! With multiple subforms
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.