Subform in Read only on Tab Control.

[Girish]

I am Creating Purchase Order Scheduling Form.

There are 3 tables 1) Po Master , 2) Po Details 3) Po Schedule.

Table 1 is linked to 2 with O2M relation, Table 2 is linked to 3 with O2M
relation.


I had put Po Part Subform (Data Sheet View) on Main Form with Tab Control.1
It works fine. I am trying to Put Delivery Shedule Subform on Tab Control.2
without creating Parent/Child link as it is not possible. I also don't need
so.
Problem I am facing is Schedule Form which is placed on Tab Control.2 is
acting as Read Only. I am not able to Add/Edit/Delete record from this
Subform. I have checked all the Allow Edit / Additions / Deletions property.
They are set correctly. But still I am facing same problem. If I open this
subform independantly I can Add/Edit record.

Please provide solution. Thanks & Regards.
Girish

 

[Maurice]

It looks like the master child fields links are bugging you there. You stated
that you couldn't get a subform without a master child field relationship.
Why not remove the master child fields in the subform. Try this... Put the
mainform in design. Now click once on the subform and look at it's
properties. You shoul see the master child field properties filled with a
linked field. Remove the linked fields from both an you should have a not
related subform on tab 2 with (maybe) the option to add-edit fields in that
specific subform.

hth

 

[boblarson]

Is the master form also set to AllowEdits, etc.? If the master is set to not
allow edits/additions/deletions it also propagates to the subform.