Help with sub-form

[John Hale]

I have form that has two sub-forms. One based on a table, and one based on a
query on that table.

The top form is in the form of an input form -- displaying one record at a
time with record navigation buttons on the bottom.

The bottom form is a datasheet view that is filtered based on certain
criteria that is established in the query.

What I am trying to do, is figure out how I can click on a record in the
datasheet view, to get it to populate that record or make current that record
in the form view for editing.

Also, one last thing, when I add a new record, I would like to update the
displayed datasheet view with current data.

Any help would be appreciated.

Thanks.