Split Forms sharing same data, w/ extended views

F

Frank

I'll try to simplify this as best as I can. I'm trying to create a master
CONTACTS form where all the contacts are listed and displayed in a window
pane on the left-hand side of the form. And then on the right hand side of
the form, are all the details of any contact you have selected on the left
hand side window pane.

Here's what I've done. I created 2 Forms. One form is designed to contain
the window pane on the left hand side [CONTACTSleft]. The other form is a
data entry form very similar to what you see in Outlook today. I labeled
that [CONTACTSright].

Then, in the [CONTACTSleft] form I attached the sub-form [CONTACTSright].
If I toggle the records on the master form, I see all the contacts in
[CONTACTSright].

Question #1: How do I create this window pane on the left hand side that
will only display all the contacts in the database by "last name", "first
name"?

Question #2. When I highlight a record in that window pane on the left, can
the sub-form on the right display the entire data for the record I have
highlighted?

I hope I've made sense. I've been wracking my brain on this one for 2 days.
I could use all the help I can. Greatly appreciated and happy holidays.

Frank
 
Top