editing in a subform

[Jean-Paul De Winter]

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

 

[John Vinson]

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]

 

[Jean-Paul De Winter]

problem solved... thanks
JP

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]

 

[Jean-Paul De Winter]

problem solved... thanks
JP

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]