Hi,
I have a continuous form (FormA) I open from a pushbutton on FormB.
Once opened I can edit all records as much as I want.
Now I open my FormB in design mode and create a subform. Here I use
FormA as the subform.
Now, when I open FormB I no longer am able to edit the data in the subform.
I can edit all data in the FomrB as much as I want but none in the
subform (former FormA)

Is this normal and what can I do about it?
Thanks
JP

On Sat, 24 Dec 2005 00:22:34 +0100, Jean-Paul De Winter
<(E-Mail Removed)> wrote:

>Hi,
>I have a continuous form (FormA) I open from a pushbutton on FormB.
>Once opened I can edit all records as much as I want.
>Now I open my FormB in design mode and create a subform. Here I use
>FormA as the subform.
>Now, when I open FormB I no longer am able to edit the data in the subform.
>I can edit all data in the FomrB as much as I want but none in the
>subform (former FormA)
>
>Is this normal and what can I do about it?

It's not at all normal.

Doublecheck the properties of the forms:

Is FormA (the Subform) correctly set with Allow Edits = Yes, Allow
Additions = Yes?
Is it based on an updateable Query?
Is there a relationship established between the tables for the two
forms?
Are FormA and FormB based on the SAME table? (If so, you will be
conflicting with yourself since the same record cannot be opened for
editing by two different forms).

John W. Vinson[MVP]

problem solved... thanks
JP

John Vinson wrote:
> On Sat, 24 Dec 2005 00:22:34 +0100, Jean-Paul De Winter
> <(E-Mail Removed)> wrote:
>
>
>>Hi,
>>I have a continuous form (FormA) I open from a pushbutton on FormB.
>>Once opened I can edit all records as much as I want.
>>Now I open my FormB in design mode and create a subform. Here I use
>>FormA as the subform.
>>Now, when I open FormB I no longer am able to edit the data in the subform.
>>I can edit all data in the FomrB as much as I want but none in the
>>subform (former FormA)
>>
>>Is this normal and what can I do about it?
>
>
> It's not at all normal.
>
> Doublecheck the properties of the forms:
>
> Is FormA (the Subform) correctly set with Allow Edits = Yes, Allow
> Additions = Yes?
> Is it based on an updateable Query?
> Is there a relationship established between the tables for the two
> forms?
> Are FormA and FormB based on the SAME table? (If so, you will be
> conflicting with yourself since the same record cannot be opened for
> editing by two different forms).
>
> John W. Vinson[MVP]

problem solved... thanks
JP

John Vinson wrote:
> On Sat, 24 Dec 2005 00:22:34 +0100, Jean-Paul De Winter
> <(E-Mail Removed)> wrote:
>
>
>>Hi,
>>I have a continuous form (FormA) I open from a pushbutton on FormB.
>>Once opened I can edit all records as much as I want.
>>Now I open my FormB in design mode and create a subform. Here I use
>>FormA as the subform.
>>Now, when I open FormB I no longer am able to edit the data in the subform.
>>I can edit all data in the FomrB as much as I want but none in the
>>subform (former FormA)
>>
>>Is this normal and what can I do about it?
>
>
> It's not at all normal.
>
> Doublecheck the properties of the forms:
>
> Is FormA (the Subform) correctly set with Allow Edits = Yes, Allow
> Additions = Yes?
> Is it based on an updateable Query?
> Is there a relationship established between the tables for the two
> forms?
> Are FormA and FormB based on the SAME table? (If so, you will be
> conflicting with yourself since the same record cannot be opened for
> editing by two different forms).
>
> John W. Vinson[MVP]