Cant edit subform of a subform

[Trystyn]

Hi,

Hoping someone can help with what I need to do to allow the following to work:

I have a main formlinked to a subform, within the subform, I have a second subform.

I am able to edit and add data in the main form, and the first subform. I am not able to edit or enter data into the second subform.

If I open the first subform directly without going into the main form, I have no problem entering data into the second subform.

All the properties are set to allow edits, allow additions, allow deletions.

Any thoughts?

 

[Steve R.]

All the properties are set to allow edits, allow additions, allow deletions.

I assume that the subform's datasource is a query. Some queries, because of their structure, prevent data from being edited. If that is the case, you need to revise how the query is designed.

Check you ability to make changes in the subform itself, without the use of the mainform. Additionally, if the datasource for the subform is query, open the query by itself and see if you can make changes.

 

[Trystyn]

I assume that the subform's datasource is a query. Some queries, because of their structure, prevent data from being edited. If that is the case, you need to revise how the query is designed.

Check you ability to make changes in the subform itself, without the use of the mainform. Additionally, if the datasource for the subform is query, open the query by itself and see if you can make changes.

Yes, the datasource is a query and it will accept input. As I said before, I can bypass the main form and enter data. I have several other subforms all functioning correctly but this is the only subform within a subform so I think there must be some conflict between this and the main form but can't figure out what it is.

 

[Steve R.]

only subform within a subform

I did not pick-up on this aspect.

so I think there must be some conflict between this and the main form.

There is the brute force approach. Change all the controls to unbound, except for one. Incrementally cycle through the controls to test the ability to edit a control when it is bound.

Also check the ability to type something into an unbound control. Technically checking the ability to edit an unbound form would seem to be unnecessary. But if you find that you can't make changes to a control when unbound, something else must be happening.

 

[Trystyn]

I did not pick-up on this aspect.

There is the brute force approach. Change all the controls to unbound, except for one. Incrementally cycle through the controls to test the ability to edit a control when it is bound.

Also check the ability to type something into an unbound control. Technically checking the ability to edit an unbound form would seem to be unnecessary. But if you find that you can't make changes to a control when unbound, something else must be happening.

I'm sorted, didn't have to resort to this in the end, the problem was that the subform was inheriting conditions not to allow edits/additions on load from the mainform which has a lock and unlock command button.

I thought unlocking one subform deep would be enough but it isn't. I had to adjust the command button accordingly.

Thanks for your time on this, always appreciated