I am trying to create an user interface (form) that has 2 parts. Each part has date from their own table (or query).

I'm look for a way to do something like this:

1) the top part of the form will have a drop down list of all records with active status. One of the fields in this table (or better, a query) will have a date (lets say 05/10/2009). This drop down will list the descriptive name.

2) The bottom portion of the interface would be the "portal" (or in MS Access speakese, subform) showing the results of a 2nd query based on the selected date from the first part ..however the results will include all records "on or after" that date.

Can someone assist or point me to a basic framework how to tie all this together?

I wish I could use FileMaker ..it's a SNAP in there.

Thanks to all!

P.S. If you wish to reply to me offlist, use niceodie at gmail dot com