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
|
|||
|
|||
Exploratory question!
Thanks for your help. I now have another query. To make the subforms visible I am using the mousemove event on the main form buttons. Is it possible to use this event to insert text into an empty label depending on which button the mouse moves over? I have a database (that I didn't design) at home that does the same thing but the VBA is horrendously complicated. thanks "Joan Wild" wrote: Set the visible property of the subform controls to false. In your code you would set the visible property of the subform control to true. Check out the samples in Help. -- Joan Wild Microsoft Access MVP scubadiver wrote: I want more than one subform and display one depending on which button I click on the main form. Can you explain how. It might be useful :-) "Joan Wild" wrote: Sure. You can change the recordsource of the subform, or the SourceObject. You can also have two subforms, and just hide/display whichever one you like. -- Joan Wild Microsoft Access MVP scubadiver wrote: Is it possible to change the subform content depending on a different button clicked in the main form? -- How many buildings collapsed on 9/11? I can tell you the answer isn't 2 !! |
#12
|
|||
|
|||
Exploratory question!
I've worked it out
"Joan Wild" wrote: Set the visible property of the subform controls to false. In your code you would set the visible property of the subform control to true. Check out the samples in Help. -- Joan Wild Microsoft Access MVP scubadiver wrote: I want more than one subform and display one depending on which button I click on the main form. Can you explain how. It might be useful :-) "Joan Wild" wrote: Sure. You can change the recordsource of the subform, or the SourceObject. You can also have two subforms, and just hide/display whichever one you like. -- Joan Wild Microsoft Access MVP scubadiver wrote: Is it possible to change the subform content depending on a different button clicked in the main form? -- How many buildings collapsed on 9/11? I can tell you the answer isn't 2 !! |
#13
|
|||
|
|||
Exploratory question!
I wouldn't use the mousemove event to do this. Two reasons:
Having the form repeatedly changing when I move the mouse would become irritating. Second, not everyone uses a mouse. I would use the click event of your buttons. Change things only when the user has actually made the choice (i.e. clicked the button, or hit enter when the button has the focus). Just change the caption property for the label in the same event as well. -- Joan Wild Microsoft Access MVP scubadiver wrote: Thanks for your help. I now have another query. To make the subforms visible I am using the mousemove event on the main form buttons. Is it possible to use this event to insert text into an empty label depending on which button the mouse moves over? I have a database (that I didn't design) at home that does the same thing but the VBA is horrendously complicated. thanks "Joan Wild" wrote: Set the visible property of the subform controls to false. In your code you would set the visible property of the subform control to true. Check out the samples in Help. -- Joan Wild Microsoft Access MVP scubadiver wrote: I want more than one subform and display one depending on which button I click on the main form. Can you explain how. It might be useful :-) "Joan Wild" wrote: Sure. You can change the recordsource of the subform, or the SourceObject. You can also have two subforms, and just hide/display whichever one you like. -- Joan Wild Microsoft Access MVP scubadiver wrote: Is it possible to change the subform content depending on a different button clicked in the main form? -- How many buildings collapsed on 9/11? I can tell you the answer isn't 2 !! |
|
Thread Tools | |
Display Modes | |
|
|