I'm trying to do the following. I need a screen with two queries listing records from the same table e.g. One query listing Calls that are open and one query listing calls that are closed. I need these queries to list the records on the right and left had sids of a form. When I select a record from either query I want the information showing in the the main form. i.e.


Query1 Main Form Query2
Open Calls Data for Open or Closed Calls
Closed Calls
Depending on which
is selected.

Thanks for any help. I can link one query with a form but not two (yet).

Use two listboxes side by side,one of the sample db's available from the MS Download site shows how to do this, I can't remember if it's Solutions or the Forms sample

Thanks Rich.