Query by Form

[Lyncroft]

I've a query by form that opens up the relevant records each with about 15 fields.

Is it possible to produce this list of records and then click on a record to bring that specific record up in form view?

I've seen a database where there is the QBF form. When you perform the search a list box produces the list in the lower half of the QBF form and you click on the appropriate record to see the details in form view. Cant work out hows it done though.

 

[wh00t]

early morning idea

create an OnClick event to filter the subform by a field

 

[Lyncroft]

Thanks for that. I think I've sorted it in my own very haphazard fashion. After I've opened the dynamic query I put a line in to return to the form, refresh the list which is based on the query. Doubtless the wheels will come off later!!