Cannot edit data on subform

[2Grandpa]

I have a form with and subform on a tab page. I am using AcformEdit in the code to open the form. I can change the data on the main form but cannot change data on the subform.

The forms are properly linked and on a field named "Audid Id". The correct data appears on the subform. Both forms are based on queries but none of the fields for the subform are in the main form query and none of the fields for the main form are in the subform query.

I use a similar method to the records but put the subform information in a temp table then append the data to the perminate table when the data is saved.

 

[ThomasLafferty]

Try this:
view your main form in design view.
To the left of the subform's ruler, there is a small square. Click it so that a small black square appears, then check display the subforms property sheet by clicking the button that looks like a form with a finger pointing to it.

Set the following properties:

Allow Edits........Yes
Allow Deletions....Yes
Allow Additions....Yes

Hope this helps!
Tom

Live once die twice; live twice die once.