Subform in a tab control not allowing any editing

[Coxylaad]

Hi all,
I've done a lot of searching on this and cannot find the answer

I have form that contains a tab control. on that tab control I have a subform.

I simply cannot get that subform to allow any input at all. I have a set of unbound text fields at the top of the subform that i use for filtering, and I cant even type in those.

When I open the subform on its own (ie not as a subform) it all works fine.

All the features of allow edits etc are set to yes. Im at a loss as to why the tab control is making everything read only.

Any ideas?

 

[arnelgp]

check your Mainform's:

Allow Additions should be set to Yes
Allow Edits should be set to Yes.

 

[SHANEMAC51]

I simply cannot get that subform to allow any input at all. I have a set of unbound text fields at the top of the subform that i use for filtering, and I cant even type in those.

When I open the subform on its own (ie not as a subform) it all works fine.

maybe at the same time the subordinate form opens only for reading

 

[Coxylaad]

yep, I change the parent forms allowedits attribute to ye and it works.

Problem is i dont want to allow edits on the parent form. I have an 'Allow Edits' button on the parent form that changed the allowedits attribute to the yes in the VBA code, but that doesnt seem to have an effect on the subform.

 

[arnelgp]

what you need is a code that will Lock all your controls on the main form (load event).
and your button, that will Unlocked the controls.

 

[Coxylaad]

yes, sorted. so the parent forms allowedits property is set to true, then when i load the foam I set it to false in VBA, and the subforms work.

Thanks everyone!

 

[arnelgp]

hen when i load the foam I set it to false in VBA, and the subforms work.

that will do.

 

[Coxylaad]

Thanks for all your help, I understand how the beforeupdate works, although I never considered a practical use for it!

much appreciated - what a nice place this is!