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 |
#11
|
|||
|
|||
Displaying a table within a table
Yes the information provided was very helpful. I am just learning code, what
does the "Me" stand for in the statement? "kingston via AccessMonster.com" wrote: Maybe I missed something. Does each client get only one classification value and hence one subform? If so, I'm not sure you should use a tab control; you can simply stack the subforms on top of each other and turn the appropriate ones on or off. Also, I'm not clear on how you wish to use the existing field [classification] . Do you mean that once it is populated, the corresponding subform will appear? You can make this happen by using the control's AfterUpdate event to control individual subform properties such as: .Visible, .Enabled, .Locked. For example: Select Case Me.Classification Case "Class1" Me.Subform1.Visible = True Me.Subform2.Visible = False ... Me.Subform7.Visible = False Case "Class2" Me.Subform1.Visible = False Me.Subform2.Visible = True ... Me.Subform7.Visible = False ... End Select cs_vision wrote: Great, can the existing field "classification" be used as a control for the tab relating to the classification chosen? Have you considered creating a tab control in your main form? It could have 7 tabs and a subform in each one corresponding to the data in the main table. [quoted text clipped - 13 lines] I have a table that I have added fields that contain lookups to other tables. How can I display the full table from that field within the main table? -- Message posted via http://www.accessmonster.com |
#12
|
|||
|
|||
Displaying a table within a table
Me. is a reference to the form itself where the code resides. It is a
shortcut for writing [Forms]![ThisFormName]. It is also very helpful because it automatically brings up a selection of properties and controls. cs_vision wrote: Yes the information provided was very helpful. I am just learning code, what does the "Me" stand for in the statement? Maybe I missed something. Does each client get only one classification value and hence one subform? If so, I'm not sure you should use a tab control; you [quoted text clipped - 29 lines] I have a table that I have added fields that contain lookups to other tables. How can I display the full table from that field within the main table? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200611/1 |
#13
|
|||
|
|||
Displaying a table within a table
Thanks so much! HAPPY FRIDAY!!!!
"kingston via AccessMonster.com" wrote: Me. is a reference to the form itself where the code resides. It is a shortcut for writing [Forms]![ThisFormName]. It is also very helpful because it automatically brings up a selection of properties and controls. cs_vision wrote: Yes the information provided was very helpful. I am just learning code, what does the "Me" stand for in the statement? Maybe I missed something. Does each client get only one classification value and hence one subform? If so, I'm not sure you should use a tab control; you [quoted text clipped - 29 lines] I have a table that I have added fields that contain lookups to other tables. How can I display the full table from that field within the main table? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200611/1 |
|
Thread Tools | |
Display Modes | |
|
|