If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Another SubForm Allow Edit Problem
Hi,
I have the same problem that is described in many previous topics, but none of the offered solutions work. - Main form is called RetailersDataEntry - Subform is called PhoneCallsSubform - they are connected through Retailer ID - Main form has AllowEdits = false - Subform has AllowEdits = true, it is not locked - Main form has a button that has on click event procedure Me.AllowEdits = True - but when that button is clicked the subform is still not editable - I've tried all various syntax on the edit button Me.PhoneCallsSubform.RetailersDataEntry = True Me.[PhoneCallsSubform].[RetailersDataEntry] = True Form![PhoneCallsSubform]![RetailersDataEntry] = True etc. none of it works. Now I've put a button that opens PhoneCallsSubform as a separate form, but that is really not great. Is anyone able to help? I'm using Access 2000. My knowledge of VB is almost non-existent, i.e. I can copy paste only. thanks |
#2
|
|||
|
|||
Another SubForm Allow Edit Problem
Hi Klara,
try; Forms!RetailersDataEntry.PhoneCallsSubform.Form.Da taEntry = True hope this helps, TonyT.. " wrote: Hi, I have the same problem that is described in many previous topics, but none of the offered solutions work. - Main form is called RetailersDataEntry - Subform is called PhoneCallsSubform - they are connected through Retailer ID - Main form has AllowEdits = false - Subform has AllowEdits = true, it is not locked - Main form has a button that has on click event procedure Me.AllowEdits = True - but when that button is clicked the subform is still not editable - I've tried all various syntax on the edit button Me.PhoneCallsSubform.RetailersDataEntry = True Me.[PhoneCallsSubform].[RetailersDataEntry] = True Form![PhoneCallsSubform]![RetailersDataEntry] = True etc. none of it works. Now I've put a button that opens PhoneCallsSubform as a separate form, but that is really not great. Is anyone able to help? I'm using Access 2000. My knowledge of VB is almost non-existent, i.e. I can copy paste only. thanks |
Thread Tools | |
Display Modes | |
|
|