So if its not subform how would I adapt the code suggestion you gave me to
goto a new form when I select the tab the form is on, but still allow the
users to page back through the existing records....or does this mean it cant
be done since its not a subform?

"ruralguy via AccessMonster.com" wrote:

> I just tried having two forms open in design mode in ac2007 and dragging one
> over the other and dropping it. It is just two separate forms. It does not
> create a SubForm on the 1st form.
>
> Lloyd wrote:
> >I am using access 2007. Yes I just dragged and dropped the form called
> >subfrmCaseReview on one of my tabs. Yes subfrmCaseReview does show up on the
> >list of form objects.
> >
> >> What version of Access are you using? You just used Drag and Drop to place
> >> the subfrmCaseReview on a tab page? Does the subfrmCaseReview show up in the
> >[quoted text clipped - 24 lines]
> >> >> >subfrmCaseReview? If so, are you certain it's a subform control? I can't
> >> >> >come up with anything else to cause that error...
>
> --
> RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
> Please post back to this forum so all may benefit.
>
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...oding/200909/1
>
>

"ruralguy via AccessMonster.com" <u12102@uwe> wrote in message
news:9c6b5fbbd5fd6@uwe...
>I just tried having two forms open in design mode in ac2007 and dragging
>one
> over the other and dropping it. It is just two separate forms. It does not
> create a SubForm on the 1st form.
<snip>

I don't have A2007 so I can't check, but I believe it should create a
subform if dragged from the database window onto the design view of a form.
This has always worked in previous versions.

I thought it was considered a sub form, I remember having to "link" the form
to the main forms primary key so the records stayed within the same record,
but now I'm not sure...do you have any other suggestions?

"Stuart McCall" wrote:

> "ruralguy via AccessMonster.com" <u12102@uwe> wrote in message
> news:9c6b5fbbd5fd6@uwe...
> >I just tried having two forms open in design mode in ac2007 and dragging
> >one
> > over the other and dropping it. It is just two separate forms. It does not
> > create a SubForm on the 1st form.
> <snip>
>
> I don't have A2007 so I can't check, but I believe it should create a
> subform if dragged from the database window onto the design view of a form.
> This has always worked in previous versions.
>
>
>

"Lloyd" <(E-Mail Removed)> wrote in message
news:F13879D1-6C83-4E3E-AA45-(E-Mail Removed)...
>I thought it was considered a sub form, I remember having to "link" the
>form
> to the main forms primary key so the records stayed within the same
> record,
> but now I'm not sure...do you have any other suggestions?
>
> "Stuart McCall" wrote:
>
>> "ruralguy via AccessMonster.com" <u12102@uwe> wrote in message
>> news:9c6b5fbbd5fd6@uwe...
>> >I just tried having two forms open in design mode in ac2007 and dragging
>> >one
>> > over the other and dropping it. It is just two separate forms. It does
>> > not
>> > create a SubForm on the 1st form.
>> <snip>
>>
>> I don't have A2007 so I can't check, but I believe it should create a
>> subform if dragged from the database window onto the design view of a
>> form.
>> This has always worked in previous versions.

I'm sure A2007 will offer multiple creation methods in the GUI. I'd better
let someone with experience of the product take this one.

One thing you could look for is a way of selecting a wizard to create a new
form with subform.

"ruralguy via AccessMonster.com" <u12102@uwe> wrote in message
news:9c6cd4867c8bb@uwe...
> Hey Stuart, I never know that worked. I've always brought down a
> SubFormControl an put it on the form. Thanks for the tip.
>
> Stuart McCall wrote:
>>>I just tried having two forms open in design mode in ac2007 and dragging
>>>one
>>> over the other and dropping it. It is just two separate forms. It does
>>> not
>>> create a SubForm on the 1st form.
>><snip>
>>
>>I don't have A2007 so I can't check, but I believe it should create a
>>subform if dragged from the database window onto the design view of a
>>form.
>>This has always worked in previous versions.

You're welcome. I think I learned the trick from the ADH for '97. Since when
I've always done it that way for no better reason than because it sizes the
subform control nicely.