Newbie form/subform question

I have a question about designing a form. I wish to design a form
that in the top half lists records one after another, that can be
scrolled through vertically and selected with normal record selectors
(no navigation controls at the bottom). But when I select one of the
records from the list, I want detail about the selected record to
appear on the bottom half of the form. I want all this information to
appear on the same screen. Here is a poorly drawn example of what I
am getting at:



Last First
---------------------- ^^
Smith John ||
Doe Jane ||
Baker Al ||
vv


Last: Doe
First: Jane
Phone: xxxxxxxx
Address: xxxxxxxx



I can get both halves on the screen by making them each a seperate
subform, but I can't get the information in the bottom half to change
when I select a record in the top half. Any suggestions would be
appreciated.

Thanks.

On 6 Jun 2004 19:29:37 -0700, (Matt) wrote:

I have a question about designing a form. I wish to design a form
that in the top half lists records one after another, that can be
scrolled through vertically and selected with normal record selectors
(no navigation controls at the bottom). But when I select one of the
records from the list, I want detail about the selected record to
appear on the bottom half of the form. I want all this information to
appear on the same screen. Here is a poorly drawn example of what I
am getting at:

By a curious coincidence, my friend Albert Kallal posted an answer
that fits this question too, and on my newsreader it was immediately
before your post. Here's Albert's reply:

You can't have a contiues form, and then place inside this a antoher
continue form.

However, you can much achieve the same effivce by:

Make a nice big large blank form.

You then drop in two contiues forms. The contiues form on the left can
show
the master data, and the continues form on the right can show the
child
data.

There is some ideas he

http://www.attcanada.net/~kallal.msn/Articles/Grid.htm

So, build 2 grids using continues forms, or 2 forms in data sheet
view.

You then create a 3rd "blank" form, and drop in the above 2 forms.

In the master form (which is now a subform), in the on current event,
you
place the following command to make the child forms follow this form.

me.Parent.Child1.Requery


In the link child/master settings for child 1, you place:

linkChildFields main_id (whatever is the name of the field
in
this sub-form that is used to relate back to the parent table)
LinkMasterFields [MasterForm].[form].[ID]


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

http://www.attcanada.net/~kallal.msn



John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Albert,

Thank you very much for your reply. I understand what you are getting
at conceptually, unfortunately I can't seem to get it to work. Please
understand that I have no doubt your instructions are correct, I am
just a beginner when it comes to Access.

When I add the "me.Parent.Child1.Requery" to the On Current event of
the master form, I get an error message that reads, "Microsoft Access
can't find the macro 'me.'"

When I try to change the link child/master settings of the subforms, I
get the message, "Can't build a link between unbound forms".

I'm sure there is something obvious that I am overlooking.

Matt

John Vinson wrote in message . ..
On 6 Jun 2004 19:29:37 -0700, (Matt) wrote:

I have a question about designing a form. I wish to design a form
that in the top half lists records one after another, that can be
scrolled through vertically and selected with normal record selectors
(no navigation controls at the bottom). But when I select one of the
records from the list, I want detail about the selected record to
appear on the bottom half of the form. I want all this information to
appear on the same screen. Here is a poorly drawn example of what I
am getting at:

By a curious coincidence, my friend Albert Kallal posted an answer
that fits this question too, and on my newsreader it was immediately
before your post. Here's Albert's reply:

You can't have a contiues form, and then place inside this a antoher
continue form.

However, you can much achieve the same effivce by:

Make a nice big large blank form.

You then drop in two contiues forms. The contiues form on the left can
show
the master data, and the continues form on the right can show the
child
data.

There is some ideas he

http://www.attcanada.net/~kallal.msn/Articles/Grid.htm

So, build 2 grids using continues forms, or 2 forms in data sheet
view.

You then create a 3rd "blank" form, and drop in the above 2 forms.

In the master form (which is now a subform), in the on current event,
you
place the following command to make the child forms follow this form.

me.Parent.Child1.Requery


In the link child/master settings for child 1, you place:

linkChildFields main_id (whatever is the name of the field
in
this sub-form that is used to relate back to the parent table)
LinkMasterFields [MasterForm].[form].[ID]


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

http://www.attcanada.net/~kallal.msn



John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

On 8 Jun 2004 04:51:17 -0700, (Matt) wrote:

Thank you very much for your reply. I understand what you are getting
at conceptually, unfortunately I can't seem to get it to work. Please
understand that I have no doubt your instructions are correct, I am
just a beginner when it comes to Access.

When I add the "me.Parent.Child1.Requery" to the On Current event of
the master form, I get an error message that reads, "Microsoft Access
can't find the macro 'me.'"

Sorry - should have explained! Rather than typing the line in the
event property, click the ... icon by the property and invoke the Code
Builder. Put this line between the Sub and End Sub lines that Access
will give you.

When I try to change the link child/master settings of the subforms, I
get the message, "Can't build a link between unbound forms".

What are the exact master/child properties, and the names of the
Subform controls?


John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

John,

I know this reply is a bit late, but I managed to get your original
instructions working, and I forgot to post the customary "thank you"
note. Thank you very much for your patience.

Thanks,
Matt

John Vinson wrote in message . ..
On 8 Jun 2004 04:51:17 -0700, (Matt) wrote:

Thank you very much for your reply. I understand what you are getting
at conceptually, unfortunately I can't seem to get it to work. Please
understand that I have no doubt your instructions are correct, I am
just a beginner when it comes to Access.

When I add the "me.Parent.Child1.Requery" to the On Current event of
the master form, I get an error message that reads, "Microsoft Access
can't find the macro 'me.'"

Sorry - should have explained! Rather than typing the line in the
event property, click the ... icon by the property and invoke the Code
Builder. Put this line between the Sub and End Sub lines that Access
will give you.

When I try to change the link child/master settings of the subforms, I
get the message, "Can't build a link between unbound forms".

What are the exact master/child properties, and the names of the
Subform controls?


John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public