Newbie form/subform question

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

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 ||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.
 
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:
Click to expand...

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 here:

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,

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 said:
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:
Click to expand...

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 here:

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
(e-mail address removed)
http://www.attcanada.net/~kallal.msn
Click to expand...
 
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.'"
Click to expand...

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".
Click to expand...

What are the exact master/child properties, and the names of the
Subform controls?
 
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
 
Back
Top