Editing Field with Subform - STUCK!

[muttsylove]

Hi There,

I've attached my database here so u can see...

I have a MAIN form which contains a Subform. That Subform contains another Subform within it. I want to enable two fields to be editable by the user on the Subform (REASON and ACTION).

IDEA 1 - frm_Main
--------------------
I developed everything already and everything works fine. The only problem is that when u go into the MAIN form, it doesn't allow me to edit the Subform fields (even when Enabled="YES" and Locked="NO").

If I go directly to the Subform itself, I have no problems.

I don't have the MAIN form bounded, I just have queries and small VBA code behind this. Hopefully, it doesn't have anything to do with this?

It would be awesome if I can use this form to do what I want! This was created for the purpose that the form does not display anything, until the user clicks on the drop-down to select their customer. I really need some help before I go mad!

IDEA 2 - TEST_frm_Main
------------------------
This was my second idea if I couldn't get the above idea to work.

I have the MAIN form bounded (linked) to the Subform. But I want the drop-down to be blank initially until the user clicks on it. Also, how can I enable the drop-down ability for the user but not let them edit the contents of it (I tried the "Enable/Locked" thing it doesn't work)..

 

[Treason]

On the properties of frm_Subform_Details2 you had "allow edits" set to no... I made it Yes and I could update the second subform

 

[muttsylove]

Thanks Treason for your time with this!

Actually, frm_Subform_Details2 is the one I don't want them to edit. The form to edit is the subform embedded within frm_Main (called frm_SubformMain_MAIN). Sorry, I should have been more clear in the original post.

The source of frm_SubformMain_MAIN is a query with some "WHERE" conditions. I'm thinking it has to do with my "WHERE" clauses that might be causing it to be uneditable...

If you double-click on frm_SubformMain_MAIN, it is editable (pass in COMPANY1 and GOOD as the parameters).

BUT! When you use it through frm_Main, edits can't be made. Argh!

Looks like I may need to go back and do some re-developing.. <sigh>