Another SubForm Allow Edit Problem

[klara.kovacic]

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

 

[TonyT]

Hi Klara,

try;

Forms!RetailersDataEntry.PhoneCallsSubform.Form.DataEntry = True

hope this helps,

TonyT..