A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Open a form in a subform depending on button.



 
 
Thread Tools Display Modes
  #1  
Old November 20th, 2009, 11:37 AM posted to microsoft.public.access.forms
JAmes
external usenet poster
 
Posts: 904
Default Open a form in a subform depending on button.

Hi
Sorry this is probably really simple but for the lfie of my can't find how
to do it.

I have a form with three buttons and an Unbound subform.

I would like that when I click one of the buttons it opens another form in
the currently unbound subform.
I can work out how to open a form in another window but I want it to open in
the subform.

Also If I wanted it to open a query instead of another form in this subform
would this change much?

Thanks
James


  #2  
Old November 20th, 2009, 01:56 PM posted to microsoft.public.access.forms
Tom van Stiphout[_2_]
external usenet poster
 
Posts: 1,653
Default Open a form in a subform depending on button.

On Fri, 20 Nov 2009 03:37:02 -0800, james
wrote:

Me.mySubformControl.SourceObject = "mySubform"

Yes. That is impossible. Use a subform in datasheet view instead.

-Tom.
Microsoft Access MVP


Hi
Sorry this is probably really simple but for the lfie of my can't find how
to do it.

I have a form with three buttons and an Unbound subform.

I would like that when I click one of the buttons it opens another form in
the currently unbound subform.
I can work out how to open a form in another window but I want it to open in
the subform.

Also If I wanted it to open a query instead of another form in this subform
would this change much?

Thanks
James

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:21 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.