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  

Split form in subform



 
 
Thread Tools Display Modes
  #1  
Old February 28th, 2009, 03:01 AM posted to microsoft.public.access.forms
Burnsie
external usenet poster
 
Posts: 19
Default Split form in subform

Anyone know if this is a bug: I put a split form in a subform. When the
subform opens, the split form only opens in single form view. And the
datasheet is nowhere to be found. This holds true whether I try to place the
datasheet at the top or bottom of the form.

If I open the subform by itself, then the split form works properly.

I have seen questions posted elsewhere on the internet without an answer.

Thanks,

Burnsie
  #2  
Old February 28th, 2009, 03:11 PM posted to microsoft.public.access.forms
Maurice
external usenet poster
 
Posts: 1,585
Default Split form in subform

No it's not a bug it's just not possible to put a splitfor as a subform on a
mainform. It's meant to be used as a main form. You could try to mimic it
yourself though by adding two subforms to the main form with one set to
single form and the other one in datasheet view. Set the master child field
the same and you should have the same effect.

hth
--
Maurice Ausum


"Burnsie" wrote:

Anyone know if this is a bug: I put a split form in a subform. When the
subform opens, the split form only opens in single form view. And the
datasheet is nowhere to be found. This holds true whether I try to place the
datasheet at the top or bottom of the form.

If I open the subform by itself, then the split form works properly.

I have seen questions posted elsewhere on the internet without an answer.

Thanks,

Burnsie

  #3  
Old February 28th, 2009, 08:02 PM posted to microsoft.public.access.forms
Burnsie
external usenet poster
 
Posts: 19
Default Split form in subform

I was guessing that would be the answer and solution. No problem creating
the two subforms. No since in doing extra work if it wasn't necessary.

Thanks,

Burnsie

"Maurice" wrote:

No it's not a bug it's just not possible to put a splitfor as a subform on a
mainform. It's meant to be used as a main form. You could try to mimic it
yourself though by adding two subforms to the main form with one set to
single form and the other one in datasheet view. Set the master child field
the same and you should have the same effect.

hth
--
Maurice Ausum


"Burnsie" wrote:

Anyone know if this is a bug: I put a split form in a subform. When the
subform opens, the split form only opens in single form view. And the
datasheet is nowhere to be found. This holds true whether I try to place the
datasheet at the top or bottom of the form.

If I open the subform by itself, then the split form works properly.

I have seen questions posted elsewhere on the internet without an answer.

Thanks,

Burnsie

  #4  
Old January 20th, 2010, 04:38 AM posted to microsoft.public.access.forms
genegal
external usenet poster
 
Posts: 4
Default Split form in subform

Although I know this post is almost a year old, I wanted to see if it was
possible to touch up on this subject again, because I too have attempted to
create 2 separate subforms and link the two by setting the master child
field, but when I did this, I was constantly asked to input the criteria for
the master child field.

I.e. I linked the Master Field to an ID field, so that when I select the ID
in a datasheet, the simple form will update dynamically. However, whenever I
select an ID in the datasheet form, it requests to enter the ID that I'm
looking for, similar to a query.

Would anyone have the solution to this problem? Thanks for your help in
advance.

Gene.

"Maurice" wrote:


No it's not a bug it's just not possible to put a splitfor as a subform on a
mainform. It's meant to be used as a main form. You could try to mimic it
yourself though by adding two subforms to the main form with one set to
single form and the other one in datasheet view. Set the master child field
the same and you should have the same effect.

hth
--
Maurice Ausum


"Burnsie" wrote:


Anyone know if this is a bug: I put a split form in a subform. When the
subform opens, the split form only opens in single form view. And the
datasheet is nowhere to be found. This holds true whether I try to place the
datasheet at the top or bottom of the form.

If I open the subform by itself, then the split form works properly.

I have seen questions posted elsewhere on the internet without an answer.

Thanks,

Burnsie

 




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 07:02 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.