If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#3
|
|||
|
|||
Newbie form/subform question
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 |
#4
|
|||
|
|||
Newbie form/subform question
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 |
#5
|
|||
|
|||
Newbie form/subform question
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 |
Thread Tools | |
Display Modes | |
|
|