I can't set the enabled/disabled property for an element of a subform

[mrwebbo]

I have a form (let's call it UserMain) with a subform (UserSub). The control that contains the UserSub form is UserSubControl.

I want to set a field called details in the subform to be disabled if it has data in it already, and enabled if it is blank.

When I try to write a macro to control the property, I wrote
[Forms].[UserMain].[UserSubControl].[Form].[details].enabled. the Macro recognizes that the field is blank or populated, but when it tries to execute the setproperty, it gives me an error that the control is misspelled or doesn't exist.

If I try with a VBA module, again the application can see if the field is blank or not, but gives me error 91 - Object variable or With block variable not set.

It's driving me crazy. Can anyone help?

[jimatqsi]

Please show us the VBA code and tell where (what event) the code is invoked.

Jim

[mrwebbo]

Thank you for your reply. I think I found the problem. I was told that you can't set properties on fields in continuous forms, and that's what I had.

Again, thank you for your help.

[OldBirdman]

You can set Enabled and a few other properties in Access 2002 & later (& maybe earlier). In Design view, choose the control UserSubControl, then on the Menu bar choose Format ...Conditional Formatting. This can allow you to set .Enabled to True if field is zero length field (""). Otherwise it will remain .Enabled=False, which you would set in design view.