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 !!

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 !!

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 !!